sf points

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

declare @limit int = 100;
declare @tag_name nvarchar(35) = 'snowflake-datawarehouse';
declare @tag_id int = (select id from tags where tagname = @tag_name and tagname like('%snowflake%'));
SELECT
rank() over (order by Count(*) desc) "Rank",
  users.id "User Link",
    Count(*) AS AnswerCount1,
    SUM(CommentCount) 
    
FROM 
    Posts
    join users on (users.id = Posts.OwnerUserid)
    
WHERE 
    users.id in ('12213140','16799700','12406178', '16889062', '363951','10051664','7561244'
,'12236724','12146963','15672689', '12619992', '11981904','16844408','16814342', '1196458', '9842780', '8339066', '12165756', '12271204', '6745597', '12271851', '12272119', '12185665', '73221', '12200988', '12256505', '12241026', '12276146', '12284087', '12273225', '5531887', '8731644', '12290405', '12294561', '12187527', '12309330', '12174761', '12285135', '3737478', '12319120', '12319116', '12322273', '17083974', '12396770', '1330430', '12487666', '12550965', '3063381', '12675859', '12675864', '12374568', '12681398','3443807')
and Posts.CreationDate >= '2020-03-03'
and PostTypeId = 2 --answers only
GROUP BY 
    users.id
ORDER BY 
    AnswerCount1 DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results