SELECT Name FROM team WHERE Team_id NOT IN (SELECT Team FROM match_season)
Return the names of teams that have no 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 )
Return the names of teams that have no match season record .