Q&A for users and developers of hardware and software for Raspberry Pi
-- total answers declare @tag_name nvarchar(35) = 'snowflake-datawarehouse'; WITH A(TotalAnswers) as ( SELECT count(*) as TotalAnswers FROM Posts WHERE PostTypeId = 2 and Posts.CreationDate >= '2019-10-07'), -- answers from support 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') -- Percent of Answers coming from Support SELECT A.TotalAnswers, B.SupportAnswers, (CAST(B.SupportAnswers as decimal)/CAST (A.TotalAnswers AS decimal)*100) as SupportContribution FROM A, B