数据库名称： MySQL/Snowflake
数据库版本： 2021
内容/问题描述：
各位资深前辈好:
我想要抓取 class 1,2,3,4,5 左下角是2月份,右上角是1月份的资料
示意图如下:
https://i.imgur.com/zmK0N1t.jpg
请问有没有办法从下列code去更改呢?
请各位大大帮忙了,谢谢
====
select
segment,
case when bad_sets.set_uuid is not null then 'bad user set' else 'good use
r set' end as is_disabled,
count(user_set_id) as user_count
from analytics.segmentation
join analytics.user_sets using (user_set_id)
left join dau.bad_sets on user_set_id = set_uuid
where score_date = '2022-02-01'
and first_country_code in ('US', 'CA')
group by 1, 2;
Code跑出来的table如下：
https://i.imgur.com/NgqOPoS.jpg
====