Pierce Technical

SQL Practice Test

Every question is generated fresh against a new random dataset. Write a query, run it, then check it against the expected result.

Beginner
0 / 0
Intermediate
0 / 0
Advanced
0 / 0
Streak
0

Loading the SQL engine…

How this question is graded
How to write values
Type
Write this
Not this
Text
Single quotes. Exact spelling and capitalization.
status = 'completed'
status = completed
Dates
Text in YYYY-MM-DD format, in single quotes.
order_date >= '2025-03-01'
order_date >= 2025-03-01
A whole year
From Jan 1 up to, not including, the next Jan 1.
hire_date >= '2025-01-01' AND hire_date < '2026-01-01'
hire_date = 2025
Numbers
No quotes, dollar signs, or commas.
salary >= 95000
salary >= '$95,000'
Missing values
IS NULL or IS NOT NULL.
tech_id IS NULL
tech_id = NULL
Ctrl + Enter runs