declare @tag_name nvarchar(35) = 'snowflake-datawarehouse';

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics Meta

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

-- 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'),
    --and Tags in ('snowflake-datawarehouse')),

-- 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')
    --and Tags in ('snowflake-datawarehouse'))

-- Percent of Answers coming from Support 
SELECT (B.SupportAnswers) as SupportContribution
FROM A, B

Enter Parameters

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