SQLRepPath
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
00/60 solved

The Basics · SELECT · ORDER BY

1. Customer directory

Concept: SELECT · ORDER BYshow

SELECT picks which columns come back and FROM names the table. ORDER BY sorts the rows: ascending (A→Z, oldest→newest) by default, or add DESC for the reverse.

Example (different data):

SELECT title, price
FROM products
ORDER BY price DESC;

Your task

Sales ops is importing customers into a new CRM and only needs a few fields, oldest accounts first.

Return name, country and signup_date for every customer, sorted by signup_date (oldest first).

Solution unlocks after 3 more tries

Starting Postgres in your browser…

query.sql
Output

Write a query and press Run Query (Ctrl/⌘ + Enter).