SELECT TOP 10 Tag.TagName ,COUNT(1) as Skaits ,COUNT(DIST...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Source Meta

Q&A about the site for people organizing, marketing or licensing open source development projects

SELECT TOP 10
   Tag.TagName
   ,COUNT(1) as Skaits
   ,COUNT(DISTINCT Usr.Id) as Unique_Users
FROM Users as Usr
  INNER JOIN Posts as Pos ON Usr.Id=Pos.OwnerUserId
  INNER JOIN PostTags as PosTg ON Pos.Id=PosTg.PostId
  INNER JOIN Tags as Tag ON PosTg.TagId=Tag.Id
WHERE 1=1 
  AND UPPER(Usr.DisplayName) LIKE 'ANDR%'
  AND Usr.CreationDate>=CAST('2019-01-01' AS DATE) 
  AND Usr.CreationDate<CAST('2020-01-01' AS DATE)
GROUP BY Tag.TagName
HAVING COUNT(DISTINCT Usr.Id)<500
AND COUNT(1)>500
ORDER BY Skaits DESC;

Enter Parameters

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