SELECT
SUM(CASE WHEN service='aa' THEN 1 ELSE 0 END) AS aa_count ,
SUM(CASE WHEN service='bb' THEN 1 ELSE 0 END) AS bb_count ,
SUM(CASE WHEN service='cc' THEN 1 ELSE 0 END) AS cc_count ,
SUM(CASE WHEN service='aa' THEN amount ELSE 0 END) AS aa_amount ,
SUM(CASE WHEN service='bb' THEN amount ELSE 0 END) AS bb_amount ,
SUM(CASE WHEN service='cc' THEN amount ELSE 0 END) AS cc_amount
FROM tb
WHERE cr_date BETWEEN '2009-01-01' AND '2009-02-01'
SUM(CASE WHEN service='aa' THEN 1 ELSE 0 END) AS aa_count ,
SUM(CASE WHEN service='bb' THEN 1 ELSE 0 END) AS bb_count ,
SUM(CASE WHEN service='cc' THEN 1 ELSE 0 END) AS cc_count ,
SUM(CASE WHEN service='aa' THEN amount ELSE 0 END) AS aa_amount ,
SUM(CASE WHEN service='bb' THEN amount ELSE 0 END) AS bb_amount ,
SUM(CASE WHEN service='cc' THEN amount ELSE 0 END) AS cc_amount
FROM tb
WHERE cr_date BETWEEN '2009-01-01' AND '2009-02-01'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货