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


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 = 
   WHERE in 
    ('9842780', '1196458','8339066', '12165756', '12271204', '6745597', '12271851' 
and PostTypeId = 2 
and Posts.CreationDate >= '2019-10-07')
    --and Tags in ('snowflake-datawarehouse'))

-- Percent of Answers coming from Support 
SELECT B.SupportAnswers/A.TotalAnswers as SupportContribution

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results