Top N per group with ties
Return the top score per game_date including ties (if two players share top score, include both). Also include rank and total players that day.
These are the tables to query for this question:
bootcamp.scoresYour answer should include these columns:
- game_date date
- player_id integer
- score integer
- score_rank bigint
- players_that_day bigint
Querying is only for logged in users!
Sign In