JobPrax
SQL CASE WHEN — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
CASE WHEN
Conditional logic, buckets and pivots.
Your progress
0
/ 40
Start the first question
All levels
Basic (25)
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
Customer-facing status labels
Basic
6
High or normal pay
Basic
7
Price bands
Basic
8
Spell out gender
Basic
9
In stock?
Basic
10
Star scores
Basic
11
Online or cash
Basic
12
Open or closed
Basic
13
Count by pay label
Basic
14
Products per band
Basic
15
Signed amounts
Basic
16
Paid or unpaid
Basic
17
Running or finished
Basic
18
Region codes
Basic
19
Senior or junior
Basic
20
Delivered out of total
Basic
21
Electronics stock only
Basic
22
City zones
Basic
23
Senior classes
Basic
24
Bulk lines
Basic
25
Fashion sale price
Basic
26
Count by bucket
Intermediate
27
Pivot with CASE
Interview
Intermediate
28
Payment method pivot
Intermediate
29
Conditional sum
Intermediate
30
Experience level
Intermediate
31
CASE in ORDER BY
Intermediate
32
Grade the marks
Intermediate
33
Percentage with CASE
Advanced
34
Fee status report
Interview
Advanced
35
Late fee calculation
Advanced
36
Subject toppers pivot
Advanced
37
Weighted score
Advanced
38
Quarter labels
Advanced
39
Flag suspicious transactions
Interview
Advanced
40
Bonus rules
Advanced