Your question is Extract Active Customer Contact Data. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| full_name | VARCHAR(100) | Customer full name |
| VARCHAR(150) | Customer email address | |
| city | VARCHAR(80) | Customer city |
| status | VARCHAR(20) | Customer account status |
| signup_date | DATE | Date the customer signed up |