SQLTeam.com | Weblogs | Forums

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.