Top 50 Case When Interview Questions
The most frequently asked Case When questions across all roles and companies, ranked by real interview frequency. Updated daily.
Use CTEs, joins, and aggregations to measure user drop-off across a multi-step signup funnel.
Facebook
Intuit
AsanaCalculate signup-to-paid conversion by channel using joins, a CTE, and grouped aggregation in PostgreSQL.
Rippling
Harness
JerryUse joins, a CTE, and aggregation to compute 30-day conversion rate by acquisition channel and customer segment.
Motive
HelloFresh
Bartech StaffingUse joins, a CTE, and conditional aggregation to compare Chime signup-to-funded conversion rates by acquisition channel.
HelloFreshRipplingMotiveUse GROUP BY and CASE WHEN to calculate HelloFresh conversion rate by acquisition channel from session-level data.
MotiveHelloFreshRipplingReplace missing sales fields with defined defaults and return a consistently ordered dataset.
University of Minnesota
The Home Depot
NationwideCalculate channel-level conversion rates from a single events table using GROUP BY and conditional aggregation.
Caesars entertainment
Berkshire Hathaway
LeagueUse joins, aggregations, and a window function to find the funnel step with the largest user drop-off.
AsanaHelloFresh
AisSign up to see every question
Create a free account to unlock this list and practice real interview questions.