Conditional Aggregation SQL interview questions
SUM(CASE WHEN ... THEN 1 ELSE 0 END) computes several rates in one pass. It is the standard way to build cancellation rates, status pivots and percentage-of-total columns.
- Cancellation Rate by CityfreeConditional Aggregationeasy
- Quarterly Cancellation RateConditional Aggregation · Dates & Timemedium
- Returned Value Share by CategoryConditional Aggregation · Joinsmedium
- Five-Star Share by Vehicle TypeConditional Aggregation · Joinsmedium
- Event Mix by Acquisition ChannelConditional Aggregation · Joinsmedium
- Campaigns That Overspent Their BudgetConditional Aggregation · Joinsmedium