add columns added with the sum aggregation function with unique where criteria for each of the aggregated columns

as I do in a query