0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners of the art and science of signal, image and video processing

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 BETWEEN '2019/01/01 00:00:00' AND '2019/12/31 23:59:59'
  GROUP BY Tag.TagName
  , CONCAT(YEAR(Pos.CreationDate),RIGHT(CONCAT(0,MONTH(Pos.CreationDate)),2))
ORDER BY Periods ASC;




/*SELECT Count(ID) as Skaits
FROM Users
WHERE UPPER(DisplayName) LIKE 'ANDR%'*/



/*SELECT Count(ID) as Skaits
FROM Posts
WHERE CreationDate BETWEEN '2019/01/01 00:00:00' AND '2019/12/31 23:59:59'*/


/*SELECT DISTINCT TagID, TagName
from PostTags
INNER JOIN Tags
ON PostTags.TagID=Tags.ID
ORDER BY TagID*/

fork query

edited dec 6 21

created dec 6 21 anonymous