Import the assignment data code and use the following logical schema to answer questions below. Note that you won't get any credits if you use codes that haven't learned in Topic 5-Joining Tables or before. Make sure to write appropriate comments to show the questions you want to answer (-1 point if you don't): TOURNAMENTS TourneyDate TourneyLocation TOURNEY MATCHES MatchID Lanes EvenLaneTeamID FK MATCH_GAMES O TourneylD FK MatchlD GameNumber CPK+- WinningTeamID FK TEAMS TeamName CaptainlDFK HO BOWLERS BOWLER SCORES BowlerID PKHMatchID BowlerLastName BowlerFirstName BowlerMiddlelnit BowlerStreetAddress BowlerCity BowlerState BowlerZipCode BowlerPhoneNumber GameNumber CPK BowlerlD RawScore HandicapScore WonGame Cd TeamlD FK 1. 2. 3. 4. 5. Show the team names (1 point) Show the team names, and captain last name and captain first name for each team (1 point) Show all bowlers' information, and their team name (1 point) Show tournament date and location (1 point) Show the raw score of each game for each bowler (1 point) Show all information of bowlers and their teams regardless they play for a team or not. (1 poin Show all first name and last name of bowler who attend at least one tournament, and tournament date and tournament location that bowler attended (1 point) Show tournament date, tournament location, odd lane team name, and even lane team name for each match in tournament (1 point) 6. 7. 8. 9. Name your own query question and answer it (1 point) 10. Name your own query question and answer it (1 point) The following criteria will be used to grade the assignment .Codes are run with detail comment, accurate, and answers are correct