SELECT TOP 10 Tag.TagName ,CONCAT(YEAR(Pos.CreationDate),...

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
   ,CONCAT(YEAR(Pos.CreationDate),RIGHT(CONCAT(0,MONTH(Pos.CreationDate)),2)) as Periods
   ,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 UPPER(Tag.TagName)='CSS'
  AND Usr.CreationDate>=CAST('2009-01-01' AS DATE) 
  AND Usr.CreationDate<CAST('2020-01-01' AS DATE)
  GROUP BY Tag.TagName
  ,CONCAT(YEAR(Pos.CreationDate),RIGHT(CONCAT(0,MONTH(Pos.CreationDate)),2))
ORDER BY Periods ASC;

Enter Parameters

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