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

Not allowed to reference any other tables in your SQL queries. Schema: 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.

COACHES SEASON cid ear r order firstname lastname season_win season_loss playoff_win playoff_loss tid TEAMS tid location name league PLAYERS ilkid firstname lastname position first season last season h feet h inches weight college birthday PLAYER RS ilkid re PLAYER RS CAREER lastnametid blk league pts oreb firstname stl ear minutes asts turnoverp ga ftm im firstname lastname league blk ilkid minutes pts dreb oreb reb asts turnoverp ga pm DRAFI draft vear draft round selection tid firstname lastname ilkid draft from league 1. Find all coaches who have coached exactly one team. List their first names, last names, 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