Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Extract Active Customer Contact Data

Easy

JoinsGroup ByAggregations

Problem

Task

You are given a customer table from a Dell Technologies marketing database and need to extract customer records for outreach. Write a SQL query that returns each active customer's ID, full name, email, city, and signup date. Only include customers whose status is 'Active', and sort the results by signup_date from newest to oldest.

Problem

Task

You are given a customer table from a Dell Technologies marketing database and need to extract customer records for outreach. Write a SQL query that returns each active customer's ID, full name, email, city, and signup date. Only include customers whose status is 'Active', and sort the results by signup_date from newest to oldest.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Eli Lilly and

Active Customer List by CityEasy

KARL STORZ

Retrieve KARL STORZ Customer RecordsEasy

AlphaSense

Normalize Messy CRM Contact DataMedium

Extract Active Customer Contact Data | Dataford Interview Questions