DataDesk
All topics
CASE WHEN — practice · DataDesk
DataDesk
How it works
Scenarios
Practice
For trainers
Pricing
Log in
Start free
SQL
CASE WHEN
Conditional logic, buckets and pivots.
0
/ 20 solved
All levels
Basic (5)
Intermediate (7)
Advanced (8)
All
To do
Solved
1
Simple label
Basic
2
Three bands
Basic
3
Translate codes
Basic
4
Pass or fail
Basic
5
Status in Hindi-English
Basic
6
Count by bucket
Intermediate
7
Pivot with CASE
Interview
Intermediate
8
Payment method pivot
Intermediate
9
Conditional sum
Intermediate
10
Experience level
Intermediate
11
CASE in ORDER BY
Intermediate
12
Grade the marks
Intermediate
13
Percentage with CASE
Advanced
14
Fee status report
Interview
Advanced
15
Late fee calculation
Advanced
16
Subject toppers pivot
Advanced
17
Weighted score
Advanced
18
Quarter labels
Advanced
19
Flag suspicious transactions
Interview
Advanced
20
Bonus rules
Advanced