What are the names of teams that do no have match season record?
CREATE TABLE match_season (Name VARCHAR, Team_id VARCHAR, Team VARCHAR); CREATE TABLE team (Name VARCHAR, Team_id VARCHAR, Team VARCHAR)
[SQL] SELECT Name FROM team WHERE NOT Team_id IN (SELECT Team FROM match_season) [/SQL]