SELECT z_username, SUM(CASE WHEN z_yydate = '2013-07-22' THEN 1 ELSE 0 END) AS 昨日预约, SUM(CASE WHEN z_dzdate = '2013-07-22' THEN 1 ELSE 0 END) AS 昨日到诊, SUM(CASE WHEN z_yydate LIKE '2013-07%' THEN 1 ELSE 0 END) AS 本月预约, SUM(CASE WHEN z_dzdate LIKE '2013-07%' THEN 1 ELSE 0 END) AS 本月到诊 FROM z_hzmanage GROUP BY z_class
SELECT z_username,
SUM(CASE WHEN z_yydate = '2013-07-22' THEN 1 ELSE 0 END) AS 昨日预约,
SUM(CASE WHEN z_dzdate = '2013-07-22' THEN 1 ELSE 0 END) AS 昨日到诊,
SUM(CASE WHEN z_yydate LIKE '2013-07%' THEN 1 ELSE 0 END) AS 本月预约,
SUM(CASE WHEN z_dzdate LIKE '2013-07%' THEN 1 ELSE 0 END) AS 本月到诊
FROM z_hzmanage GROUP BY z_class