sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: country 
columns : [['country id', 'number'], ['country name', 'text'], ['capital', 'text'], ['official native language', 'text']]

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

 -- Table: match season 
columns : [['season', 'number'], ['player', 'text'], ['position', 'text'], ['country', 'number'], ['team', 'number'], ['draft pick number', 'number'], ['draft class', 'text'], ['college', 'text']]

 -- Table: player 
columns : [['player id', 'number'], ['player', 'text'], ['years played', 'text'], ['total wl', 'text'], ['singles wl', 'text'], ['doubles wl', 'text'], ['team', '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: Return the colleges that have players who play the Midfielder position, as well as players who play the Defender position.
SQL: SELECT College FROM match_season WHERE POSITION  =  "Midfielder" INTERSECT SELECT College FROM match_season WHERE POSITION  =  "Defender"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 climbers are there?
SQL: SELECT count(*) FROM climber
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Count the number of climbers.
SQL: SELECT count(*) FROM climber
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 climbers in descending order of points.
SQL: SELECT Name FROM climber ORDER BY Points DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of the climbers, ordered by points descending?
SQL: SELECT Name FROM climber ORDER BY Points DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 climbers whose country is not Switzerland.
SQL: SELECT Name FROM climber WHERE Country != "Switzerland"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of climbers who are not from the country of Switzerland?
SQL: SELECT Name FROM climber WHERE Country != "Switzerland"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 maximum point for climbers whose country is United Kingdom?
SQL: SELECT max(Points) FROM climber WHERE Country  =  "United Kingdom"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Return the maximum number of points for climbers from the United Kingdom.
SQL: SELECT max(Points) FROM climber WHERE Country  =  "United Kingdom"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 distinct countries are the climbers from?
SQL: SELECT COUNT(DISTINCT Country) FROM climber
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Count the number of different countries that climbers are from.
SQL: SELECT COUNT(DISTINCT Country) FROM climber
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of mountains in ascending alphabetical order?
SQL: SELECT Name FROM mountain ORDER BY Name ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Give the names of mountains in alphabetical order.
SQL: SELECT Name FROM mountain ORDER BY Name ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 countries of mountains with height bigger than 5000?
SQL: SELECT Country FROM mountain WHERE Height  >  5000
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Return the countries of the mountains that have a height larger than 5000.
SQL: SELECT Country FROM mountain WHERE Height  >  5000
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 highest mountain?
SQL: SELECT Name FROM mountain ORDER BY Height DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Return the name of the mountain with the greatest height.
SQL: SELECT Name FROM mountain ORDER BY Height DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 distinct ranges of the mountains with the top 3 prominence.
SQL: SELECT DISTINCT Range FROM mountain ORDER BY Prominence DESC LIMIT 3
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 different ranges of the 3 mountains with the highest prominence?
SQL: SELECT DISTINCT Range FROM mountain ORDER BY Prominence DESC LIMIT 3
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of climbers and the names of mountains they climb.
SQL: SELECT T1.Name ,  T2.Name FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of climbers and the corresponding names of mountains that they climb?
SQL: SELECT T1.Name ,  T2.Name FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 climbers and the heights of mountains they climb.
SQL: SELECT T1.Name ,  T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of climbers and the corresponding heights of the mountains that they climb?
SQL: SELECT T1.Name ,  T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 height of the mountain climbed by the climber with the maximum points.
SQL: SELECT T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID ORDER BY T1.Points DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 height of the mountain climbined by the climbing who had the most points?
SQL: SELECT T2.Height FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID ORDER BY T1.Points DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 distinct names of mountains climbed by climbers from country "West Germany".
SQL: SELECT DISTINCT T2.Name FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID WHERE T1.Country  =  "West Germany"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 different names of mountains ascended by climbers from the country of West Germany?
SQL: SELECT DISTINCT T2.Name FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID WHERE T1.Country  =  "West Germany"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 times used by climbers to climb mountains in Country Uganda.
SQL: SELECT T1.Time FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID WHERE T2.Country  =  "Uganda"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 times used by climbers who climbed mountains in the country of Uganda?
SQL: SELECT T1.Time FROM climber AS T1 JOIN mountain AS T2 ON T1.Mountain_ID  =  T2.Mountain_ID WHERE T2.Country  =  "Uganda"
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 countries and the number of climbers from each country.
SQL: SELECT Country ,  COUNT(*) FROM climber GROUP BY Country
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 climbers are from each country?
SQL: SELECT Country ,  COUNT(*) FROM climber GROUP BY Country
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 countries that have more than one mountain.
SQL: SELECT Country FROM mountain GROUP BY Country HAVING COUNT(*)  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Which countries have more than one mountain?
SQL: SELECT Country FROM mountain GROUP BY Country HAVING COUNT(*)  >  1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 mountains that do not have any climber.
SQL: SELECT Name FROM mountain WHERE Mountain_ID NOT IN (SELECT Mountain_ID FROM climber)
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of countains that no climber has climbed?
SQL: SELECT Name FROM mountain WHERE Mountain_ID NOT IN (SELECT Mountain_ID FROM climber)
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 countries that have mountains with height more than 5600 stories and mountains with height less than 5200.
SQL: SELECT Country FROM mountain WHERE Height  >  5600 INTERSECT SELECT Country FROM mountain WHERE Height  <  5200
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 countries that have both mountains that are higher than 5600 and lower than 5200?
SQL: SELECT Country FROM mountain WHERE Height  >  5600 INTERSECT SELECT Country FROM mountain WHERE Height  <  5200
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 range that has the most number of mountains.
SQL: SELECT Range FROM mountain GROUP BY Range ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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: Which range contains the most mountains?
SQL: SELECT Range FROM mountain GROUP BY Range ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 mountains with height more than 5000 or prominence more than 1000.
SQL: SELECT Name FROM mountain WHERE Height  >  5000 OR Prominence  >  1000
-- Language PostgreSQL
        -- Tables: 
             -- Table: mountain 
columns : [['mountain id', 'number'], ['name', 'text'], ['height', 'number'], ['prominence', 'number'], ['range', 'text'], ['country', 'text']]

 -- Table: climber 
columns : [['climber id', 'number'], ['name', 'text'], ['country', 'text'], ['time', 'text'], ['points', 'number'], ['mountain id', '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 names of mountains that have a height of over 5000 or a prominence of over 1000?
SQL: SELECT Name FROM mountain WHERE Height  >  5000 OR Prominence  >  1000
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 body builders are there?
SQL: SELECT count(*) FROM body_builder
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 scores of body builders in ascending order.
SQL: SELECT Total FROM body_builder ORDER BY Total ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 snatch score and clean jerk score of body builders in ascending order of snatch score.
SQL: SELECT Snatch ,  Clean_Jerk FROM body_builder ORDER BY Snatch ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 snatch score of body builders?
SQL: SELECT avg(Snatch) FROM body_builder
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 clean and jerk score of the body builder with the highest total score?
SQL: SELECT Clean_Jerk FROM body_builder ORDER BY Total DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 birthdays of people in ascending order of height?
SQL: SELECT Birth_Date FROM People ORDER BY Height ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 body builders?
SQL: SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 body builders whose total score is higher than 300?
SQL: SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Total  >  300
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 name of the body builder with the greatest body weight?
SQL: SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Weight DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 birth date and birth place of the body builder with the highest total points?
SQL: SELECT T2.Birth_Date ,  T2.Birth_Place FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Total DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 heights of body builders with total score smaller than 315?
SQL: SELECT T2.Height FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Total  <  315
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 total score of body builders with height bigger than 200?
SQL: SELECT avg(T1.Total) FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Height  >  200
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 body builders in descending order of total scores?
SQL: SELECT T2.Name FROM body_builder AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Total DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 each birth place along with the number of people from there.
SQL: SELECT Birth_Place ,  COUNT(*) FROM people GROUP BY Birth_Place
-- Language PostgreSQL
        -- Tables: 
             -- Table: body builder 
columns : [['body builder id', 'number'], ['people id', 'number'], ['snatch', 'number'], ['clean jerk', 'number'], ['total', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['birth date', 'text'], ['birth place', '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 most common birth place of people?
SQL: SELECT Birth_Place FROM people GROUP BY Birth_Place ORDER BY COUNT(*) DESC LIMIT 1