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