text: CREATE TABLE match_season (POSITION VARCHAR) -- Show the position of players and the corresponding number of players. SELECT POSITION, COUNT(*) FROM match_season GROUP BY POSITION CREATE TABLE match_season (Country VARCHAR); CREATE TABLE country (Country_name VARCHAR, Country_id VARCHAR) -- Show the country names and the corresponding number of players. SELECT Country_name, COUNT(*) FROM country AS T1 JOIN match_season AS T2 ON T1.Country_id = T2.Country GROUP BY T1.Country_name CREATE TABLE match_season (player VARCHAR, College VARCHAR) -- Return all players sorted by college in ascending alphabetical order. SELECT player FROM match_season ORDER BY College CREATE TABLE match_season (POSITION VARCHAR) -- Show the most common position of players in match seasons. SELECT POSITION FROM match_season GROUP BY POSITION ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE match_season (College VARCHAR) -- Show the top 3 most common colleges of players in match seasons. SELECT College FROM match_season GROUP BY College ORDER BY COUNT(*) DESC LIMIT 3 CREATE TABLE match_season (College VARCHAR) -- Show the name of colleges that have at least two players. SELECT College FROM match_season GROUP BY College HAVING COUNT(*) >= 2 CREATE TABLE match_season (College VARCHAR) -- Show the name of colleges that have at least two players in descending alphabetical order. SELECT College FROM match_season GROUP BY College HAVING COUNT(*) >= 2 ORDER BY College DESC