MySQL Multi-Aggregated Rows in Crosstab Queries — DatabaseJournal.com
MySQL's crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the...