Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one...

Extracted text: Part 1: Use the following schema to answer the questions 1-3 below. This schema refers to a gaming organization. There can be any number of players per game. Each game and each tournament has one winner; if the game or tournament is ongoing, the winner is null. The gameWinner and tournamentWinner attributes are foreign keys for memberlD. Member (memberID, memberName, joinDate) Game (gamelD, gameType, gameDate, gameWinner, tournamentName) MemberGame (memberlD, gamelD) Tournament (tournamentName, tournamentWinner) 1. Write mySOL queries to generate the following tables: a. Each tournament name with the number of games in that tournament won by the tournament winner. b. A list of game IDs and game types sorted by game type then game id. A list of player IDs of all players who have played a game with the date of the first game played by that player. с.