1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 17 19

created nov 17 19 ayuthika