sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: item 
columns : [['item id', 'number'], ['title', 'text']]

 -- Table: review 
columns : [['a id', 'number'], ['user id', 'number'], ['item id', 'number'], ['rating', 'number'], ['rank', 'number']]

 -- Table: useracct 
columns : [['user id', 'number'], ['name', 'text']]

 -- Table: trust 
columns : [['source user id', 'number'], ['target user id', 'number'], ['trust', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Find the names of the items that did not receive any review.
SQL: SELECT title FROM item WHERE i_id NOT IN (SELECT i_id FROM review)
-- Language PostgreSQL
        -- Tables: 
             -- Table: item 
columns : [['item id', 'number'], ['title', 'text']]

 -- Table: review 
columns : [['a id', 'number'], ['user id', 'number'], ['item id', 'number'], ['rating', 'number'], ['rank', 'number']]

 -- Table: useracct 
columns : [['user id', 'number'], ['name', 'text']]

 -- Table: trust 
columns : [['source user id', 'number'], ['target user id', 'number'], ['trust', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Find the number of users who did not write any review.
SQL: SELECT count(*) FROM useracct WHERE u_id NOT IN (SELECT u_id FROM review)
-- Language PostgreSQL
        -- Tables: 
             -- Table: item 
columns : [['item id', 'number'], ['title', 'text']]

 -- Table: review 
columns : [['a id', 'number'], ['user id', 'number'], ['item id', 'number'], ['rating', 'number'], ['rank', 'number']]

 -- Table: useracct 
columns : [['user id', 'number'], ['name', 'text']]

 -- Table: trust 
columns : [['source user id', 'number'], ['target user id', 'number'], ['trust', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Find the number of items without any review.
SQL: SELECT count(*) FROM item WHERE i_id NOT IN (SELECT i_id FROM review)
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many players are there?
SQL: SELECT count(*) FROM player
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the names of players in ascending order of votes.
SQL: SELECT Player_name FROM player ORDER BY Votes ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the gender and occupation of players?
SQL: SELECT Gender ,  Occupation FROM player
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the name and residence for players whose occupation is not "Researcher".
SQL: SELECT Player_name ,  residence FROM player WHERE Occupation != "Researcher"
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the names of sponsors of players whose residence is either "Brandon" or "Birtle".
SQL: SELECT Sponsor_name FROM player WHERE Residence  =  "Brandon" OR Residence  =  "Birtle"
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the name of the player with the largest number of votes?
SQL: SELECT Player_name FROM player ORDER BY Votes DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show different occupations along with the number of players in each occupation.
SQL: SELECT Occupation ,  COUNT(*) FROM player GROUP BY Occupation
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Please show the most common occupation of players.
SQL: SELECT Occupation FROM player GROUP BY Occupation ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the residences that have at least two players.
SQL: SELECT Residence FROM player GROUP BY Residence HAVING COUNT(*)  >=  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the names of players and names of their coaches.
SQL: SELECT T3.Player_name ,  T2.coach_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the names of players coached by the rank 1 coach.
SQL: SELECT T3.Player_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID WHERE T2.Rank  =  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the names and genders of players with a coach starting after 2011.
SQL: SELECT T3.Player_name ,  T3.gender FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID WHERE T1.Starting_year  >  2011
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the names of players and names of their coaches in descending order of the votes of players.
SQL: SELECT T3.Player_name ,  T2.coach_name FROM player_coach AS T1 JOIN coach AS T2 ON T1.Coach_ID  =  T2.Coach_ID JOIN player AS T3 ON T1.Player_ID  =  T3.Player_ID ORDER BY T3.Votes DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the names of players that do not have coaches.
SQL: SELECT Player_name FROM player WHERE Player_ID NOT IN (SELECT Player_ID FROM player_coach)
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Show the residences that have both a player of gender "M" and a player of gender "F".
SQL: SELECT Residence FROM player WHERE gender  =  "M" INTERSECT SELECT Residence FROM player WHERE gender  =  "F"
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many coaches does each club has? List the club id, name and the number of coaches.
SQL: SELECT T1.club_id ,  T1.club_name, count(*) FROM club AS T1 JOIN coach AS T2 ON T1.club_id  =  T2.club_id GROUP BY T1.club_id
-- Language PostgreSQL
        -- Tables: 
             -- Table: player 
columns : [['player id', 'number'], ['sponsor name', 'text'], ['player name', 'text'], ['gender', 'text'], ['residence', 'text'], ['occupation', 'text'], ['votes', 'number'], ['rank', 'text']]

 -- Table: club 
columns : [['club id', 'number'], ['club name', 'text'], ['region', 'text'], ['start year', 'number']]

 -- Table: coach 
columns : [['coach id', 'number'], ['player name', 'text'], ['gender', 'text'], ['club id', 'number'], ['rank', 'number']]

 -- Table: player coach 
columns : [['player id', 'number'], ['coach id', 'number'], ['starting year', 'number']]

 -- Table: match result 
columns : [['rank', 'number'], ['club id', 'number'], ['gold', 'number'], ['big silver', 'number'], ['small silver', 'number'], ['bronze', 'number'], ['points', 'number']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many gold medals has the club with the most coaches won?
SQL: SELECT T1.club_id ,  T1.gold FROM match_result AS T1 JOIN coach AS T2 ON T1.club_id  =  T2.club_id GROUP BY T1.club_id ORDER BY count(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: How many gymnasts are there?
SQL: SELECT count(*) FROM gymnast
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Count the number of gymnasts.
SQL: SELECT count(*) FROM gymnast
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the total points of gymnasts in descending order.
SQL: SELECT Total_Points FROM gymnast ORDER BY Total_Points DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the total points for all gymnasts, ordered by total points descending?
SQL: SELECT Total_Points FROM gymnast ORDER BY Total_Points DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the total points of gymnasts in descending order of floor exercise points.
SQL: SELECT Total_Points FROM gymnast ORDER BY Floor_Exercise_Points DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the total points of gymnasts, ordered by their floor exercise points descending?
SQL: SELECT Total_Points FROM gymnast ORDER BY Floor_Exercise_Points DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the average horizontal bar points for all gymnasts?
SQL: SELECT avg(Horizontal_Bar_Points) FROM gymnast
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the average horizontal bar points across all gymnasts.
SQL: SELECT avg(Horizontal_Bar_Points) FROM gymnast
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of people in ascending alphabetical order?
SQL: SELECT Name FROM People ORDER BY Name ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the names of people, ordered alphabetically.
SQL: SELECT Name FROM People ORDER BY Name ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of gymnasts?
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the names of the gymnasts.
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of gymnasts whose hometown is not "Santo Domingo"?
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T2.Hometown != "Santo Domingo"
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the names of gymnasts who did not grow up in Santo Domingo.
SQL: SELECT T2.Name FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T2.Hometown != "Santo Domingo"
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the age of the tallest person?
SQL: SELECT Age FROM people ORDER BY Height DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the age of the person with the greatest height.
SQL: SELECT Age FROM people ORDER BY Height DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: List the names of the top 5 oldest people.
SQL: SELECT Name FROM People ORDER BY Age DESC LIMIT 5
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the names of the five oldest people?
SQL: SELECT Name FROM People ORDER BY Age DESC LIMIT 5
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the total point count of the youngest gymnast?
SQL: SELECT T1.Total_Points FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Age ASC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the total points of the gymnast with the lowest age.
SQL: SELECT T1.Total_Points FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID ORDER BY T2.Age ASC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What is the average age of all gymnasts?
SQL: SELECT avg(T2.Age) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Return the average age across all gymnasts.
SQL: SELECT avg(T2.Age) FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: What are the distinct hometowns of gymnasts with total points more than 57.5?
SQL: SELECT DISTINCT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T1.Total_Points  >  57.5
-- Language PostgreSQL
        -- Tables: 
             -- Table: gymnast 
columns : [['gymnast id', 'number'], ['floor exercise points', 'number'], ['pommel horse points', 'number'], ['rings points', 'number'], ['vault points', 'number'], ['parallel bars points', 'number'], ['horizontal bar points', 'number'], ['total points', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['age', 'number'], ['height', 'number'], ['hometown', 'text']]

You are a SQL code translator. You have been given the Table data above. Your role is to translate natural language to PostgreSQL. 
You should not select columns that are not part of the tables provided to you. Think step by step.
Your only output should be SQL code. Do not include any other text. Only SQL code.



Question: Give the different hometowns of gymnasts that have a total point score of above 57.5.
SQL: SELECT DISTINCT T2.Hometown FROM gymnast AS T1 JOIN people AS T2 ON T1.Gymnast_ID  =  T2.People_ID WHERE T1.Total_Points  >  57.5