CREATE TABLE match_season (Name VARCHAR, Team_id VARCHAR, Team VARCHAR)
CREATE TABLE team (Name VARCHAR, Team_id VARCHAR, Team VARCHAR)

What are the names of teams that do no have match season record?
SELECT Name FROM team WHERE NOT Team_id IN (SELECT Team FROM match_season)
SELECT "Name" FROM "team" WHERE NOT "Team_id" IN (SELECT "Team" FROM "match_season")