/* Q1: How many unique posts recorded in year of 2022? A...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker

Q&A for serious players and enthusiasts of poker

/*

Q1: How many unique posts recorded in year of 2022? And please sort the counts by Post Type.

Q2: Which users had the most  views, by top 20, and what their Display Names are?

Q3: Please list out the top 3 Users’ most viewed post, and calculate the total score for those posts.

Q4: please review the table available on the right, and raise one more question to yourself, to show what kind of info you would like to share with us.

*/
select top 20 
  DisplayName
  , views
from users
order by views desc

;

select top 20
  DIsplayName
  , count(displayname) displaycount
  , sum(views) count
 from users
 group by displayname
 order by sum(views) desc
 
 ;
 
 select * 
 from users
 where displayname like 'Jon%'

Enter Parameters

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