SQL query help please

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.


STATS (ID_Player, ID_Play, ID_Saison, Ranking, Score, Game_Time)

I have to find:

  1. 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).

what have you tried ?

please provide some real data example, then only anyone can help.