11 slide

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

SELECT COUNT(1) as Skaits    
    ,COUNT(DISTINCT Usr.Id) as UniqueUsers
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 UPPER(Usr.DisplayName) LIKE 'ANDR%'
AND UPPER(Tag.TagName) = 'CSS'
  AND Usr.CreationDate BETWEEN '2009/01/01 00:00:00' AND '2009/12/31 23:59:59'
GROUP BY Tag.TagName
ORDER BY Skaits DESC;




/*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*/

Enter Parameters

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