数据透视表PHP / MySQL

您可以使用子查询来执行此操作，然后生成并汇总此数据。尝试一些类似的方法：

select week,     count(*) as total,     sum(technical) as technical,     sum(non_technical) as non_technical) from(    select week,     case(type) when 'Technical' then 1 else 0 END as technical,     case(type) when 'Non-Technical' then 1 else 0 END as non_technical) as dataGROUP BY week