Extract Active Customer Contact Data | Dataford Interview Questions

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.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
full_name	VARCHAR(100)	Customer full name
email	VARCHAR(150)	Customer email address
city	VARCHAR(80)	Customer city
status	VARCHAR(20)	Customer account status
signup_date	DATE	Date the customer signed up

Your question is Extract Active Customer Contact Data. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
full_name	VARCHAR(100)	Customer full name
email	VARCHAR(150)	Customer email address
city	VARCHAR(80)	Customer city
status	VARCHAR(20)	Customer account status
signup_date	DATE	Date the customer signed up

Your question is Extract Active Customer Contact Data. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.