What are the names of teams that do no have match season record?
create table match_season (name varchar, team_id varchar, team varchar, PRIMARY KEY (name)); create table team (name varchar, team_id varchar, team varchar, PRIMARY KEY (name))
select name from team where not team_id in (select team from match_season)