DataDesk
All topics
SELECT & WHERE — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
SELECT & WHERE
Pick columns and filter rows with conditions.
0
/ 20 solved
All levels
Basic (8)
Intermediate (8)
Advanced (4)
All
To do
Solved
1
All columns
Basic
2
Pick columns
Basic
3
Filter by a number
Basic
4
Filter by text
Basic
5
Two conditions with AND
Basic
6
Either condition with OR
Basic
7
IN a list
Basic
8
BETWEEN a range
Basic
9
Pattern matching
Intermediate
10
Contains a word
Intermediate
11
NOT IN
Intermediate
12
Brackets matter
Intermediate
13
Filter by date
Intermediate
14
Calculated column
Intermediate
15
Projects still running
Intermediate
16
Big projects in 2024
Intermediate
17
Second letter is 'a'
Advanced
18
Long-serving and well paid
Interview
Advanced
19
Gmail-style check
Advanced
20
Expensive items in stock
Advanced