select name, sum(num) as num, station
from order_s
where '2007-04-01' between b_date and e_date and name = '新周刊'
group by name, station
from order_s
where '2007-04-01' between b_date and e_date and name = '新周刊'
group by name, station
SELECT name,station,SUM(num) AS Expr4
FROM dbo.order_s
--WHERE name = '新周刊' and CONVERT( VARCHAR(11),CONVERT(DATETIME, b_date, 111) )='Apr 1 2007'
GROUP BY name, CONVERT( VARCHAR(11),CONVERT(DATETIME, b_date, 111) ), station