按月按季度统计

select to_char(wbsj,'mm') m, count(distinct id) ,substr(wbsj,0,4) y from 表 where 条件 group by substr(wbsj,0,4), to_char(wbsj,'mm');按月统计，按季度的话把mm换成q，quarter的简写。