Question

SQL语句怎么按照月统计数量

foodid uesrid mak datetime
1 1 3 2013-12-05 00:00:00
1 2 4 2013-11-05 00:00:00
2 1 3 2013-10-03 00:00:00

表是类似这样的 怎么样按照foodid和月份统计每个月用户的评价数，用的语句一直说datetime列名错误

Answer 1

Select foodid, month(datetime), sum(mak) from [tablename1] where year(datetime) = 2013 group by foodid,month(datetime)

Answer 2

select foodid,userid,mak,datepart(mm,datetime) as 月份 from 表名 group by foodid,userid,mak,datepart(mm,datetime)