- 首先計算每個月份的各個品牌的訂單量
- 按月進(jìn)行分組對訂單量排序得出序號准浴，并篩選
select
*
from
(select
a.品牌
,a.mon
,a.num
,row_number()over(PARTITION by a.mon order by a.num desc) as num_rank
from
(SELECT
*
,date_format(日期,"%Y-%m-01") mon
,count(orser_id) num
FROM `alcohol`
group by
date_format(日期,"%Y-%m-01") ,品牌) a
) b
where b.num_rank<4
order by b.mon asc
