Writing a Simple SQL Query | Dataford Interview Questions

Can you write a simple SQL query to extract customer data from a database?

Use the customers table and return only customers whose status is active. Include the requested customer fields and present the results in ascending customer ID order.

Output

One row per active customer
Columns: customer_id, customer_name, and email
Sort by customer_id in ascending order

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer's full name
email	VARCHAR(255)	Customer email address
status	VARCHAR(20)	Customer account status

Your question is Writing a Simple SQL Query. 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