统计每个product_code的 run_state='0','2','3','4'各有多少个；
表结构：
实现SQL
SELECT hp.PRODUCT_CODE, SUM(IF(hp.RUN_STATE = '0',hp.RUN_STATE,0)) AS '运行', SUM(IF(hp.RUN_STATE = '1',hp.RUN_STATE,0)) AS '暂停', SUM(IF(hp.RUN_STATE = '2',hp.RUN_STATE,0)) AS '待删', SUM(IF(hp.RUN_STATE = '3',hp.RUN_STATE,0)) AS '空闲', SUM(IF(hp.RUN_STATE = '4',hp.RUN_STATE,0)) AS '保留' FROM rm_has_produced hp GROUP BY hp.PRODUCT_CODE
查询的结果
