Conditional Aggregation with CASE?!
CASE inside SUM creates conditional aggregation! You can sum only certain rows based on conditions. This conditional math will transform your data!
#sql #sqltricks #case #sum #conditionalaggregation #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #aggregation #advancedsql