0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

/*

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.

*/

---Q1
select pt.name
  , count(*) postcount
from posts p 
join posttypes pt 
  on p.posttypeid=pt.id
where year(creationdate)=2022
group by  pt.name
order by pt.name;

fork query

edited nov 29

created nov 29 anonymous