SELECT Name FROM team WHERE Team_id NOT IN (SELECT Team FROM match_season)
What are the names of teams that do no have match season record?
SELECT Name FROM team WHERE Team_id NOT IN ( SELECT Team FROM match_season )
select name from team where team_id not in ( select team from match_season )
What are the names of teams that do no have match season record ?