Editing SQL 2
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 54: | Line 54: | ||
==== 1-6 Tennis query ==== | ==== 1-6 Tennis query ==== | ||
1. output TEAMNO of the teams in which the player with the number 27 is not captain | 1. output TEAMNO of the teams in which the player with the number 27 is not captain | ||
2. output of PLAYERNO, NAME and INITIALS of the players who have won at least one match | 2. output of PLAYERNO, NAME and INITIALS of the players who have won at least one match | ||
3. output of playerNo and name of the players who have received at least one penalty | 3. output of playerNo and name of the players who have received at least one penalty | ||
4. output of playerNo and name of the players, who have received at least one penalty over 50. | 4. output of playerNo and name of the players, who have received at least one penalty over 50. | ||
5. output of PlayerNo and name of players born in the same year as R. Parmenter | 5. output of PlayerNo and name of players born in the same year as R. Parmenter | ||
6. output of playerNo and name of the oldest player from Stratford | 6. output of playerNo and name of the oldest player from Stratford | ||