Hello everyone, I'm new on the forum, shortly I have an SQL exam and I can not solve some exercises.
I hope in your help.
Given:
STATS (ID_Player, ID_Play, ID_Saison, Ranking, Score, Game_Time)
I have to find:
- For each Play of the Season N.3, the Player who got a higher score then ther first classified. (This request is not inconsistent because the classification(Ranking) of a player is based on its score and playing time).