SQL Query for Customer Data

00:00

5 left

SQL Query for Customer Data

EasySQL · PostgreSQL

Problem

Write a simple SQL query to extract data from a customer table for Unknowns.

Assume the table is named customers. Return the requested customer fields for every customer, ordered by customer ID.

Output

One row per customer
Columns: customer_id, customer_name, and email
Include all customers and sort by customer_id ascending

Schema

customers

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

Tablescustomers

CodePostgreSQL

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

Run your query to see results here.