Put your SQL statement under the following lines:

4. Find the average height (in centimeters) of each team coached by Phil Jackson in each season. Print the team name, season and the average height value (in centimeters), and sort the results by the average height. 5. Find the coach(es) (first name and last name) who have coached the largest number of players in year 1999.

schema

create table teams (tid varchar(30), location varchar(30), name varchar(30),league varchar(30), primary key (tid, league)); create table coaches_season (cid varchar(30), year int, yr_order int,firstname varchar(30), lastname varchar(30), season_win int, season_loss int,playoff_win int, playoff_loss int, tid varchar(30), primary key (cid, year,yr_order)); create table draft (draft_year int, draft_round int, selection int, tidvarchar(30), firstname varchar(30), lastname varchar(30), ilkid varchar(30),draft_from varchar(100), league varchar(30)); create table players (ilkid varchar(30), firstname varchar(30), lastnamevarchar(30), position varchar(1), first_season int, last_season int, h_feet int,h_inches real, weight real, college varchar(100), birthday varchar(30), primarykey (ilkid)); create table player_rs_career (ilkid varchar(30), firstname varchar(30),lastname varchar(30), league varchar(10), gp int, minutes int, pts int, drebint, oreb int, reb int, asts int, stl int, blk int, turnover int, pf int, fgaint, fgm int, fta int, ftm int, tpa int, tpm int); create table player_rs (ilkid varchar(30), year int, firstname varchar(30),lastname varchar(30), tid varchar(30), league varchar(10), gp int, minutes int,pts int, dreb int, oreb int, reb int, asts int, stl int, blk int, turnover int,pf int, fga int, fgm int, fta int, ftm int, tpa int, tpm int, primary key(ilkid,year, tid));

Answer in psql please thanks