Show the team names.
select name from team
Which of them have at least one record in the match season?
select name from team where team_id in (select team from match_season)
Which are not?
select name from team where team_id not in (select team from match_season)