Q&A for serious players and enthusiasts of chess
declare @limit int = 100; declare @tag_name nvarchar(35) = 'snowflake-datawarehouse'; declare @tag_id int = (select id from tags where tagname = @tag_name); SELECT users.id "User Link", Count(*) AS AnswerCount1 FROM Posts join users on (users.id = Posts.OwnerUserid) WHERE users.id in ('12480431') and Posts.CreationDate >= '2019-12-03' and PostTypeId = 2 --answers only GROUP BY users.id ORDER BY AnswerCount1 DESC