SQL SELECT

SELECT names the columns to return. WHERE filters rows. ORDER BY controls their order.

SQL
SELECT name, score
FROM students
WHERE score >= 80
ORDER BY score DESC;
Read the full lesson