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