Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
--select views, count(distinct Id) AS distinct_Users
--group by views order by distinct_Users desc
select Id, case when Views >=0 AND Views <= 2 then '0-2'
else '10+' end as views_group, count(Id) AS Users
group by Id, views