SQL Lesson 1: SELECT, WHERE and ORDER BY

SheetDrill SQL SQL Lesson 1 · SELECT, WHERE and ORDER BY

SQL · Lesson 1

Ctrl/⌘ + Enter to run

✓

SQL Lesson 1 done.

You can pull exactly the columns and rows you need from a table, sort them and take the top few. That's most of what people do with SQL day to day.

SQL Lesson 2: COUNT, SUM and GROUP BY →

What you're learning

A query starts with SELECT (which columns) and FROM (which table): SELECT name, salary FROM employees. * means every column. WHERE keeps only the rows that match a condition; combine conditions with AND and OR. Text goes in single quotes: 'Sales'.

ORDER BY salary DESC sorts highest first (ASC, the default, is lowest first). LIMIT 3 keeps the first three rows. LIKE '2021%' matches text that starts with 2021; % means "anything".