[Question] Top 2 Players per Platform

Question: Inspect the table logged_plays attached to this community post. Write a query that pulls the top 2 users with the largest number of plays in each platform. Avoid using unions in your final solution.

Original Table:

 

Desired Output:

 


Ready for the solution? Click here!

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 mths agoLast active
  • 94Views
  • 1 Following