题解 | 符合销售额的品牌信息

with t as (select 品牌号,品牌名,品类号,date_format(月份,'%Y-%m') as 月份,电商平台,sum(销售额) as 销售额 from 品牌表
join 月销售统计表 using(品牌号)
group by 品牌号,品牌名,品类号,月份,电商平台
having 销售额 >=10000 and year(月份) = 2019)

select 品牌号,品牌名,count(distinct 品类号) as 品类号数量 from t
group by 品牌号,品牌名