I always forget the syntax for “CASE” in SQL.   SELECT other_columns,         SUM(CASE col WHEN val THEN result ELSE 0 END) AS singlevalue_result,         SUM(CASE WHEN col BETWEEN val1 AND val2 THEN result ELSE 0 END) AS betwen_values_result,         SUM(CASE WHEN col1 = val3 AND  [ Read More ]