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 124: | Line 124: | ||
==== 1-5 Tennis query ==== | ==== 1-5 Tennis query ==== | ||
1. NAME, INITIALS and number of sets won for each player | 1. NAME, INITIALS and number of sets won for each player | ||
2. NAME, PEN_DATE and AMOUNT sorted in descending order by AMOUNT | 2. NAME, PEN_DATE and AMOUNT sorted in descending order by AMOUNT | ||
3. TEAMNO, NAME (of the captain) per team | 3. TEAMNO, NAME (of the captain) per team | ||
4. NAME (player name), WON, LOST of all won matches | 4. NAME (player name), WON, LOST of all won matches | ||
5. PLAYERNO, NAME and penalty amount for each team player. If a player has not yet received a penalty, it should still be issued. Sorting should be done in ascending order of penalty amount | 5. PLAYERNO, NAME and penalty amount for each team player. If a player has not yet received a penalty, it should still be issued. Sorting should be done in ascending order of penalty amount | ||