🗄️ SQL Playground

Write real SQL queries to search, sort and filter data — just like a real database developer. Pre-loaded school database with guided exercises.

Designed with the WJEC specification in mind

CS A-Level Unit 4DigiTech A-Level Unit 4

💻

Database:

📝

📖

SQL	What it does
SELECT column FROM table	Choose which columns you want to see
SELECT * FROM table	Show all columns (everything)
WHERE condition	Filter rows — only show ones that match
ORDER BY column ASC/DESC	Sort the results (ascending or descending)
COUNT(*)	Count how many rows there are
GROUP BY column	Group results by a column (e.g. count per house)
INNER JOIN t2 ON ...	Combine two tables together using a shared column
INSERT INTO ... VALUES	Add a new row to a table
UPDATE ... SET ... WHERE	Change existing data in a table
DELETE FROM ... WHERE	Remove rows from a table