Writing a Simple SQL Query

EasySQL · PostgreSQL

Problem

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

Tablescustomers

CodePostgreSQL

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

Run your query to see results here.