select count的条件怎么加

[yadoufeng]

CREATE TABLE `log_addmoney` (
  `paysn` varchar(20) NOT NULL,
  `uid` int(11) NOT NULL,
  `roleid` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `isfirst` tinyint(4) NOT NULL,
  `unixtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `moneycat` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 PACK_KEYS=0;

如何再追加一列，就是每天的 isfirst=1的总数

select Date(unixtime) as dt,SUM(money) ,count(*) as num from log_addmoney group by dt order by dt;
这个查询出来的是 日期，充值总数，充值人数，现在需要统计该天的首冲人数。

谢谢

[龑]

SELECT DATE(unixtime) AS dt,SUM(money) ,COUNT(*),SUM(IF(isfirst=1,1,0)) AS 首冲人数 AS num  FROM log_addmoney  GROUP BY dt ORDER BY dt;

[rucypli]

select Date(unixtime) as dt,SUM(money) ,count(*) as num sum(case when isfirst=1 then 1 else 0 end) from log_addmoney group by dt order by dt;