记录一次简单查询

 

 

SELECT play_date AS 日期 , COUNT(IF(STATUS='胜',1,NULL)) AS 胜  , COUNT(IF(STATUS='负',1,NULL)) AS 负   FROM tablename1 GROUP BY play_date;