select views_group, Users from ( select case when Views ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Constructed Languages

Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

select views_group, Users
from (

select case when Views > 5 then '5+'
else cast(Views as varchar) end as views_group, count(distinct Id) AS Users
from Users
group by Views)a

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results