- Put your SQL statement under the following lines: 1. Find all the coaches who

Question

- 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

Explanation / Answer

select firstname,lastname from coaches_season where cid in
(select cid from coaches_season group by cid having count(cid)=1 );

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.