select case when size(appusage) < 100 then 'num_100'
when size(appusage) < 100 then 'num_100'
when size(appusage) < 200 then 'num_200'
when size(appusage) < 300 then 'num_300'
when size(appusage) < 400 then 'num_400'
when size(appusage) < 500 then 'num_500'
when size(appusage) < 600 then 'num_600'
when size(appusage) < 700 then 'num_700'
when size(appusage) < 800 then 'num_800'
when size(appusage) < 900 then 'num_900'
when size(appusage) < 1000 then 'num_1000'
when size(appusage) < 1500 then 'num_1500'
when size(appusage) < 2000 then 'num_2000'
when size(appusage) < 3000 then 'num_3000'
else 'other' end
from miuicore.screentime_user_raw_data
group by
case when size(appusage) < 100 then 'num_100'
when size(appusage) < 100 then 'num_100'
when size(appusage) < 200 then 'num_200'
when size(appusage) < 300 then 'num_300'
when size(appusage) < 400 then 'num_400'
when size(appusage) < 500 then 'num_500'
when size(appusage) < 600 then 'num_600'
when size(appusage) < 700 then 'num_700'
when size(appusage) < 800 then 'num_800'
when size(appusage) < 900 then 'num_900'
when size(appusage) < 1000 then 'num_1000'
when size(appusage) < 1500 then 'num_1500'
when size(appusage) < 2000 then 'num_2000'
when size(appusage) < 3000 then 'num_3000'
else 'other' end