SQL for Customer Retrieval

EasySQL · PostgreSQL

Write a SQL query to retrieve customer information from a database for a Happy Money reporting use case.

Use the customers table and return only customers whose status is active.

Output

One row per active customer with customer_id, customer_name, email, and customer_status.
Sort the results by customer_id in ascending order.

customers

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

Tablescustomers

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.