Answer Happy

4. SQL Questions [501 Give an expression in SQL for each of the following queries: Players (nr, name, int, birth date, gender, joined, streer, houses, postcode, town, phonero, leagueno) Teams (anno, playemo, division) Matches (matchno, teanne, playemo, won, lost) Penalties (paymentse, playemo, payment date, anunt) Commitee Members (playerno, begin date, end de position) a 161 Get the name, number, gender and birth date of each female player born before 1990. b. 161 For each player who has incurred at least one penalty, give the player number and average penalty amount. . [7] In which town do more than 2 players live? d. [7] Get the player numbers of players who were born in the same year as player 27. 181 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. f. 18) What is the highest penalty incurred by a player resident in Stratford? g. 18) Find the name and number of each player whose name begins with a capital B.