CSTTP SQL Lab

Ask questions of a database by typing SQL. Pick a mission, write a query, press Run. Nothing you do here can break anything.

Practice data only. Events are made up, and the words table holds English placeholders.

Results

Run a query to see results here.

Cheat sheet

SELECT which columns
FROM which table
WHERE keep matching rows
ORDER BY sort (add DESC to flip)
LIMIT keep the first few
COUNT(*) count rows
GROUP BY one row per group
INSERT INTO add a row
UPDATE ... SET change rows
JOIN ... ON link two tables