text: 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) CREATE TABLE country (Country_name VARCHAR, Country_id VARCHAR); CREATE TABLE match_season (Country VARCHAR, Position VARCHAR) -- What are the names of countries that have both players with position forward and players with position defender? SELECT T1.Country_name FROM country AS T1 JOIN match_season AS T2 ON T1.Country_id = T2.Country WHERE T2.Position = "Forward" INTERSECT SELECT T1.Country_name FROM country AS T1 JOIN match_season AS T2 ON T1.Country_id = T2.Country WHERE T2.Position = "Defender" CREATE TABLE match_season (College VARCHAR, POSITION VARCHAR) -- Which college have both players with position midfielder and players with position defender? SELECT College FROM match_season WHERE POSITION = "Midfielder" INTERSECT SELECT College FROM match_season WHERE POSITION = "Defender" CREATE TABLE climber (Id VARCHAR) -- How many climbers are there? SELECT COUNT(*) FROM climber CREATE TABLE climber (Name VARCHAR, Points VARCHAR) -- List the names of climbers in descending order of points. SELECT Name FROM climber ORDER BY Points DESC CREATE TABLE climber (Name VARCHAR, Country VARCHAR) -- List the names of climbers whose country is not Switzerland. SELECT Name FROM climber WHERE Country <> "Switzerland"