0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people studying math at any level and professionals in related fields

declare @tag_name nvarchar(35) = 'snowflake-datawarehouse';
WITH B(SupportAnswers) as (
   SELECT count(*) as SupportAnswers
   FROM Posts 
   JOIN Users 
   ON Posts.OwnerUserId = users.id 
   WHERE users.id in 
    ('9842780', '1196458','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')
and PostTypeId = 2 
and Posts.CreationDate >= '2019-10-07')

SELECT (B.SupportAnswers * 100) as SupportContribution
FROM B

fork query

edited nov 17 19

created nov 17 19 anonymous