- Put your SQL statement under the following lines: 1. Find all the coaches who have coached exactly ONE team. List their firstnames followed by their last names

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));

Answer in psql please thansl