0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT KAT, COUNT(1) AS POCET 
FROM(
    select ownerUserId,
           pocet,
           case  when pocet<=10 then 9
                 else 11
           end as kat
    from(
      SELECT  p.ownerUserId, count(1) as pocet
      FROM POSTS P
      WHERE  p.ownerUserId is not null
        and PostTypeId in (1,2)
      group by p.ownerUserId
     )A
    )B
GROUP BY KAT;

view current version

edited sep 20

created sep 20 jon.doe45742