|To obtain part sums of a column based on specific conditions, use If() or |
select sum( if(condition1, col, 0) ) as cond1, sum( if(condition2, col, 0) ) as cond2, ...etc... from tbl;It's also called crosstabbing or pivoting. The pivot is on the expression that conditions the aggregating function. Pito Salas invented the method while he was developing spreadsheet software for Lotus Corp. For more on the topic see the "Crosstabs (Pivot tables)" heading here.
Last updated 25 Jan 2020