1.表结构
2.表数据
3.查询语句
SELECT
enterprise_id,
sum( CASE WHEN type = '0' THEN 1 ELSE '0' END ) AS 普惠,
sum( CASE WHEN type = '1' THEN 1 ELSE '0' END ) AS 高端,
sum( CASE WHEN type = '2' THEN 1 ELSE '0' END ) AS 中端,
sum( CASE WHEN type = '3' THEN 1 ELSE '0' END ) AS 低端
FROM
product
GROUP BY
enterprise_id
4.查询结果