月年季度统计sql模型

--access
select avg(BC) as TJ,format(TDate,'yyyy-mm-dd') as SJ  from HDataBJ001 where TDate>=#2016-7-8 15:28:23# and TDate <=#2016-9-6 15:28:23# group by format(TDate,'yyyy-mm-dd') order by format(TDate,'yyyy-mm-dd') desc
--sql
  select avg(bc) as bv,CONVERT(varchar(10),area_date,120) as area_date   from FJ_KQQXWYS where area_date>='2016-08-27' and area_date <='2016-09-01'  group by CONVERT(varchar(10),area_date,120)  order by area_date desc