Support Contribution for Tag snowflake-datawarehouse


Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

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 = 
   WHERE in 
    ('9842780', '1196458','8339066', '12165756', '12271204', '6745597', '12271851' 
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 

Enter Parameters

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