求一SQL语句或存储过程

[icejd]

表结构如下图
http://www.vs2007.cn/1.jpg
我用如下SQL语句
SELECT CONVERT(char(10), AddTime, 120) AS 日期, COUNT(*) AS 数量
FROM Comego_charge
WHERE (MONTH(AddTime) = '8')
GROUP BY CONVERT(char(10), AddTime, 120)
ORDER BY CONVERT(char(10), AddTime, 120)
得出结果为
http://www.vs2007.cn/2.jpg
求得的数据为这个月份中每一天车辆的总和
但是我还想求得这个月份中每一天不同车型的和，又要如何弄呢，比方说car_type='1'的和，car_type='2'的和
不会弄了，谢谢大家，分不够再加

[dawugui]

select car_type,convert(varchar(10),addtime,120) 日期 , COUNT(*) AS 数量
from Comego_charge
where month(addtime) = 8
group by car_type,convert(varchar(10),addtime,120)

[dawugui]

--上述为所有车型的和
--如果求car_type='1',car_type='2'的和

select car_type,convert(varchar(10),addtime,120) 日期 , COUNT(*) AS 数量
from Comego_charge
where month(addtime) = 8 and car_type='1' and car_type='2'
group by car_type,convert(varchar(10),addtime,120)

[icejd]

不对哦，不是这样子的

[Limpire]

按照你的要求，就是这样弄的

结果不对那你想怎么弄

[dawugui]

SELECT CONVERT(char(10), AddTime, 120) AS 日期, sum(money) AS 数量
FROM Comego_charge
WHERE (MONTH(AddTime) = '8')
GROUP BY CONVERT(char(10), AddTime, 120)
ORDER BY CONVERT(char(10), AddTime, 120)

[dawugui]

select car_type,convert(varchar(10),addtime,120) 日期 , sum(money) AS 数量
from Comego_charge
where month(addtime) = 8
group by car_type,convert(varchar(10),addtime,120)

[dawugui]

--上述为所有车型的和
--如果求car_type='1',car_type='2'的和

select car_type,convert(varchar(10),addtime,120) 日期 , sum(money) AS 数量
from Comego_charge
where month(addtime) = 8 and car_type='1' and car_type='2'
group by car_type,convert(varchar(10),addtime,120)

[dawugui]

估计是算money
如果不是,那算我又搞错了.

[$扫地僧$]

SELECT CONVERT(char(10), AddTime, 120) AS 日期,
COUNT(*) AS 数量,
sum(case when car_type='1' then 1 else 0 end) as car_type1的和,
sum(case when car_type='2' then 1 else 0 end) as car_type1的和
FROM Comego_charge
WHERE (MONTH(AddTime) = '8')
GROUP BY CONVERT(char(10), AddTime, 120)
ORDER BY CONVERT(char(10), AddTime, 120)

[ojuju10]

select car_type,convert(varchar(10),addtime,120) 日期 , COUNT(*) AS 数量
from Comego_charge
where month(addtime) = 8 and car_type in (1,2)
group by car_type,convert(varchar(10),addtime,120)