Amazon
Medium
Data ScientistRetrieve First Active and Last Inactive Dates per User
Data Manipulation (SQL/Python)
166
9
August 4, 2025
SQL CASE WHEN Interview Questions
CASE WHEN questions test how you express conditional logic in SQL.
Expect bucketing, conditional aggregation, and custom labels based on multiple conditions.
Interviewers look for correct ordering of conditions and clear reasoning.
41Questions
21Companies
Easy 0 • Medium 41 • Hard 0Difficulty mix
Common SQL CASE WHEN interview patterns
- Bucketing continuous values into ranges
- Conditional counts and sums
- Custom labels based on multiple conditions
- Handling NULLs in CASE logic
- Conditional joins and filters
SQL CASE WHEN interview questions
Filter and sort
Meta
Medium
Data ScientistAnalyze Group Call Adoption Using SQL Queries
Data Manipulation (SQL/Python)
152
1
July 12, 2025
Amazon
Medium
Data ScientistExplain MySQL to MS SQL Server query syntax differences.
Data Manipulation (SQL/Python)
104
0
August 4, 2025
Fannie Mae
Medium
Data ScientistUnderstand SQL Aggregations and Joins: Key Differences Explained
Data Manipulation (SQL/Python)
101
0
July 12, 2025
Point72
Medium
Data ScientistConvert Dates to Calendar Quarter Labels in SQL/Python
Data Manipulation (SQL/Python)
78
0
July 12, 2025
Meta
Medium
Data ScientistDesign SQL Query for Shop Visibility and User Activity Metrics
Data Manipulation (SQL/Python)
76
0
July 12, 2025
OpenAI
Medium
Data ScientistDesign Schema and Logic for Subscription Event Tracking
Data Manipulation (SQL/Python)
69
0
July 12, 2025
TikTok
Medium
Data ScientistIdentify Top Discounts and Monitor Code Submissions
Data Manipulation (SQL/Python)
67
0
July 12, 2025
PayPal
Medium
Data ScientistAnalyze Transactions and Classify by Amount in SQL
Data Manipulation (SQL/Python)
62
0
August 4, 2025
Meta
Medium
Data ScientistCalculate Total Interactions for Each Product
Data Manipulation (SQL/Python)
55
0
July 12, 2025
TikTok
Medium
Data ScientistTiktok DS Interview Questions
Data Manipulation (SQL/Python)
10
1
June 26, 2025
Robinhood
Medium
Data ScientistWrite SQL and Python for transaction analytics
Data Manipulation (SQL/Python)
5
0
October 13, 2025
Capital One
Medium
Data ScientistDetermine Country with Most 'Sunny' Days
Data Manipulation (SQL/Python)
42
0
July 12, 2025
TikTok
Medium
Data ScientistCount buggy vs non-buggy by employer
Data Manipulation (SQL/Python)
1
0
October 13, 2025
Amazon
Medium
Business Intelligence EngineerIdentify Top-Buying Customers Daily with SQL Query
Data Manipulation (SQL/Python)
15
0
July 12, 2025
Thumbtack
Medium
Data ScientistCompare list/dict; parse JSON/CSV at scale
Data Manipulation (SQL/Python)
2
0
October 13, 2025
PayPal
Medium
Data ScientistWrite conditional aggregates with CASE WHEN
Data Manipulation (SQL/Python)
2
0
July 31, 2025
Meta
Medium
Data ScientistCompute CTR overall and by campaign type
Data Manipulation (SQL/Python)
2
0
October 13, 2025
Adobe
Medium
Software EngineerImplement scalable word count locally
Data Manipulation (SQL/Python)
0
0
September 6, 2025
DoorDash
Medium
Data ScientistWrite complex SQL on DoorDash data
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Common mistakes with SQL CASE WHEN
- Missing ELSE clauses for unmatched cases
- Overlapping or incorrect condition order
- Not handling NULLs explicitly
- Using CASE when a JOIN or lookup table is clearer
- Mixing data types in CASE outputs
How CASE WHEN questions are evaluated in interviews
Correct logic and ordering are more important than syntax tricks.
Explain your assumptions and how edge cases are handled.
Keep CASE statements readable and well-structured.