0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

with tids as (select distinct name from badges 
where tagbased = 1),
c1 as (select name, count(*) as c1s from badges where  tagbased = 1 and class =1 group by name),
c2 as (select name, count(*) as c2s from badges where  tagbased = 1 and class =2 group by name),
c3 as (select name, count(*) as c3s from badges where  tagbased = 1 and class =3 group by name)
select c3.name, c1.c1s, c2.c2s 
from c1 left outer join c2 on c1.name = c2.name 
left outer join c3 on c3. name = c2.name

fork query

edited nov 28

created nov 28 anonymous