- 4 Sql Questions 50 Give An Expression In Sql For Each Of The Following Queries Players Nr Name Init Birth Date 1 (42.51 KiB) Viewed 79 times
4. SQL
Questions [50] Give an expression in SQL for each of the following queries: Players (nr, name, init, birth_date, gender, joined, street, houseno, postcode, town, phoneno, leagueno) Teams (teamno, playerno, division) Matches (matchno, teamno, playerno, won, lost) Penalties (paymentno, playerno, payment_date, amount) Commitee Members (playerno, begin_date, end_date, position) a. [6] Get the name, number, gender and birth date of each female player born before 1990. b. [6] For each player who has incurred at least one penalty, give the player number and average penalty amount. e. 171 In which town do more than 2 players live? d. 17] Get the player numbers of players who were born in the same year as player 27. e. [8] For each penalty, get the payment number, the amount of the penalty, the player number, and the name and initials of the player who incurred the penalty. Use pseudonyms.