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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language

Q&A for linguists, teachers and students of the Ukrainian language

--declare @limit int = 100;
declare @tag_name nvarchar(35) = 'snowflake-datawarehouse';
declare @tag_id int = (select id from tags where tagname = @tag_name);

SELECT
    users.id as "user Link", users.reputation, users.LastAccessDate, 
    sum(Posts.viewCount)
    
FROM 
    Users
    join Posts on (users.id = Posts.OwnerUserid)
    
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 Posts.CreationDate >= '2019-10-07'
--and PostTypeId = 2 --answers only
GROUP BY 
    users.id, users.reputation, users.LastAccessDate

Enter Parameters

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