1.表
2.sql语句
SELECT
am.city_id,
am.dept_id,
( CASE am.menu_code WHEN '20012' THEN am.app_count ELSE 0 END ) AS '我的已办',
( CASE am.menu_code WHEN '20013' THEN am.app_count ELSE 0 END ) AS '我的待办',
( CASE am.menu_code WHEN '30019' THEN am.app_count ELSE 0 END ) AS '补贴发放',
( CASE am.menu_code WHEN '30023' THEN am.app_count ELSE 0 END ) AS '重点工作'
FROM
`app_menu_count` am
GROUP BY
am.org_id,am.dept_id
3.结果