select count(X.ownerDisplayName) as POcet_Uzivatelu From ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

select
count(X.ownerDisplayName) as POcet_Uzivatelu
From (select
        P.ownerDisplayName,
        count(P.ID) as PocetPostu
      from
         posts P
      where
        P.OwnerUserID is not null
      Group by
        P.ownerDisplayName
      having
      count(P.ID)>10) X

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results