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 count(1) as pocetc 
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
  having count(1)>10
)a;
--415474

view current version

edited sep 20

created sep 20 jon.doe45742