Top 50 Case When Interview Questions

Use CTEs, joins, and aggregations to measure user drop-off across a multi-step signup funnel.

JoinsCase WhenAggregationsFacebookIntuitAsana

Calculate signup-to-paid conversion by channel using joins, a CTE, and grouped aggregation in PostgreSQL.

JoinsCase WhenAggregationsRipplingHarnessJerry

Use joins, a CTE, and aggregation to compute 30-day conversion rate by acquisition channel and customer segment.

JoinsGroup ByCase WhenMotiveHelloFreshBartech Staffing

Use joins, a CTE, and conditional aggregation to compare Chime signup-to-funded conversion rates by acquisition channel.

JoinsGroup ByCase WhenHelloFreshRipplingMotive

Use GROUP BY and CASE WHEN to calculate HelloFresh conversion rate by acquisition channel from session-level data.

JoinsCase WhenAggregationsMotiveHelloFreshRippling

Use CTEs, joins, and conditional aggregation to measure a daily visit-to-checkout-to-purchase funnel for web users.

JoinsCase WhenAggregationsHelloFreshIntuitQuora