Log inSign up

SQL for Business Users

Query real business data with SELECT, JOIN, GROUP BY and window functions.

Full course requires the Pro plan. Upgrade — preview lessons are free.
  1. SELECT, WHERE and ORDER BY
  2. JOINs without the confusion 🔒
  3. GROUP BY and aggregates 🔒
  4. Window functions for rankings and running totals 🔒

SELECT, WHERE and ORDER BY

A query reads: what you want (SELECT), from where (FROM), which rows (WHERE), in what order (ORDER BY).

SELECT name, total FROM orders WHERE total > 1000 ORDER BY total DESC;

Log in to track progress and earn a certificate.