CASE WHEN

DuckDB FILTER Clause in Action: The Ultimate Guide to Conditional Aggregation