Write some SQL queries. The database contains the following six tables:

You are not allowed to reference any other tables in the SQL queries. Your goal for this project will be to write 10 SELECT queries to answer the 10 questions below. Note that you should use the cid, ilkid, and tid fields to identify coaches, players, and teams, as there may be coaches, players, and teams that share the same name.

1. coaches_season: table describing the performance of coaches in one season 2. teams: table with basic information about NBA teams 3. players: table with basic information about NBA players 4. player-rs: table with detailed information about how players performed in a given regular season 5. playerrs.career: table summarizing players' regular season performance across their careers 6. draft: table with information about the NBA draft COACHES SEASON cid order firstname lastname season win season loss playoff win playoff loss tid TEAMS tid location PLAYERS ilkid firstname lastname oson first season last season h feet h inches weight college birthday PLAYER RS ilkid firstname lastname tid stl minutes pts leaguegp ga asts blk turnoverpf gm PLAYER RS CAREER ilkid firstname lastname league gp turnoverp minutes ts asts blk ga fta ftm im DRAFT year draft round sclection tid firstname lastname ilkid draft from league I. Find all oaches who have coachel exnly on t ist their firslast ns, and cids 2. Find all players who played on a Boston team and a Denver team (possibly in different seasons). List their first names and ilkids. 3. Find everyone who was a coach and a player on the same team in the same season. List their first 4. Find the average height (in centimeters) of each team in the 2001 season. Print the team name, the 5. Find the coaches (first name, last name, and cid) who coached the largest number of players in 1999 name, last name, the team, and the year for every time this happened. coach name, and the average height, and return your results in order of increasing height. 1. coaches_season: table describing the performance of coaches in one season 2. teams: table with basic information about NBA teams 3. players: table with basic information about NBA players 4. player-rs: table with detailed information about how players performed in a given regular season 5. playerrs.career: table summarizing players' regular season performance across their careers 6. draft: table with information about the NBA draft COACHES SEASON cid order firstname lastname season win season loss playoff win playoff loss tid TEAMS tid location PLAYERS ilkid firstname lastname oson first season last season h feet h inches weight college birthday PLAYER RS ilkid firstname lastname tid stl minutes pts leaguegp ga asts blk turnoverpf gm PLAYER RS CAREER ilkid firstname lastname league gp turnoverp minutes ts asts blk ga fta ftm im DRAFT year draft round sclection tid firstname lastname ilkid draft from league I. Find all oaches who have coachel exnly on t ist their firslast ns, and cids 2. Find all players who played on a Boston team and a Denver team (possibly in different seasons). List their first names and ilkids. 3. Find everyone who was a coach and a player on the same team in the same season. List their first 4. Find the average height (in centimeters) of each team in the 2001 season. Print the team name, the 5. Find the coaches (first name, last name, and cid) who coached the largest number of players in 1999 name, last name, the team, and the year for every time this happened. coach name, and the average height, and return your results in order of increasing height