sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneurs?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneurs.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneurs whose investor is not "Rachel Elnaugh"?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor != "Rachel Elnaugh"
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneurs do no not have the investor Rachel Elnaugh.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor != "Rachel Elnaugh"
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 weight of the shortest person?
SQL: SELECT Weight FROM people ORDER BY Height ASC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 weight of the shortest person.
SQL: SELECT Weight FROM people ORDER BY Height ASC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneur with the greatest weight?
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Weight DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 name of the heaviest entrepreneur.
SQL: SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Weight DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 money requested by entrepreneurs with height more than 1.85?
SQL: SELECT sum(T1.Money_Requested) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Height  >  1.85
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 total money requested by entrepreneurs who are taller than 1.85.
SQL: SELECT sum(T1.Money_Requested) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Height  >  1.85
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 dates of birth of entrepreneurs with investor "Simon Woodroffe" or "Peter Jones"?
SQL: SELECT T2.Date_of_Birth FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor  =  "Simon Woodroffe" OR T1.Investor  =  "Peter Jones"
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 dates of birth for entrepreneurs who have either the investor Simon Woodroffe or Peter Jones.
SQL: SELECT T2.Date_of_Birth FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Investor  =  "Simon Woodroffe" OR T1.Investor  =  "Peter Jones"
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 weights of entrepreneurs in descending order of money requested?
SQL: SELECT T2.Weight FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 weights of entrepreneurs, ordered descending by amount of money requested.
SQL: SELECT T2.Weight FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 investors of entrepreneurs and the corresponding number of entrepreneurs invested by each investor?
SQL: SELECT Investor ,  COUNT(*) FROM entrepreneur GROUP BY Investor
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneurs correspond to each investor?
SQL: SELECT Investor ,  COUNT(*) FROM entrepreneur GROUP BY Investor
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 investor that has invested in the most number of entrepreneurs?
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 investor who have invested in the greatest number of entrepreneurs.
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 investors that have invested in at least two entrepreneurs?
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor HAVING COUNT(*)  >=  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 investors who have invested in two or more entrepreneurs.
SQL: SELECT Investor FROM entrepreneur GROUP BY Investor HAVING COUNT(*)  >=  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneurs and their companies in descending order of money requested?
SQL: SELECT T2.Name ,  T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 entrepreneurs and their corresponding investors, ordered descending by the amount of money requested?
SQL: SELECT T2.Name ,  T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Money_Requested
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 people that are not entrepreneurs.
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM entrepreneur)
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 who are not entrepreneurs?
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM entrepreneur)
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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: Show the investors shared by entrepreneurs that requested more than 140000 and entrepreneurs that requested less than 120000.
SQL: SELECT Investor FROM entrepreneur WHERE Money_Requested  >  140000 INTERSECT SELECT Investor FROM entrepreneur WHERE Money_Requested  <  120000
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 investors who have invested in both entrepreneurs who requested more than 140000 and entrepreneurs who requested less than 120000?
SQL: SELECT Investor FROM entrepreneur WHERE Money_Requested  >  140000 INTERSECT SELECT Investor FROM entrepreneur WHERE Money_Requested  <  120000
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 distinct companies are there?
SQL: SELECT count(DISTINCT Company) FROM entrepreneur
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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 different companies.
SQL: SELECT count(DISTINCT Company) FROM entrepreneur
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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: Show the company of the tallest entrepreneur.
SQL: SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Height DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: entrepreneur 
columns : [['entrepreneur id', 'number'], ['people id', 'number'], ['company', 'text'], ['money requested', 'number'], ['investor', 'text']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['date of birth', '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: Which company was started by the entrepreneur with the greatest height?
SQL: SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Height DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 perpetrators are there?
SQL: SELECT count(*) FROM perpetrator
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 date of perpetrators in descending order of the number of people killed.
SQL: SELECT Date FROM perpetrator ORDER BY Killed DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 number of people injured by perpetrators in ascending order.
SQL: SELECT Injured FROM perpetrator ORDER BY Injured ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 number of people injured by all perpetrators?
SQL: SELECT avg(Injured) FROM perpetrator
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 location of the perpetrator with the largest kills.
SQL: SELECT LOCATION FROM perpetrator ORDER BY Killed DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 order of height?
SQL: SELECT Name FROM People ORDER BY Height ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 perpetrators?
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 perpetrators whose country is not "China"?
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Country != "China"
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 perpetrator with the biggest weight.
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Weight DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 kills of the perpetrators with height more than 1.84.
SQL: SELECT sum(T2.Killed) FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID WHERE T1.Height  >  1.84
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 perpetrators in country "China" or "Japan"?
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID WHERE T2.Country  =  "China" OR T2.Country  =  "Japan"
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 perpetrators in descending order of the number of people they injured?
SQL: SELECT T1.Height FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Injured DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 countries of perpetrators? Show each country and the corresponding number of perpetrators there.
SQL: SELECT Country ,  COUNT(*) FROM perpetrator GROUP BY Country
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 country that has the most perpetrators?
SQL: SELECT Country ,  COUNT(*) FROM perpetrator GROUP BY Country ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 countries that have at least two perpetrators?
SQL: SELECT Country ,  COUNT(*) FROM perpetrator GROUP BY Country HAVING COUNT(*)  >=  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 perpetrators in descending order of the year.
SQL: SELECT T1.Name FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T2.Year DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 people that are not perpetrators.
SQL: SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM perpetrator)
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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: Show the countries that have both perpetrators with injures more than 50 and perpetrators with injures smaller than 20.
SQL: SELECT Country FROM perpetrator WHERE Injured  >  50 INTERSECT SELECT Country FROM perpetrator WHERE Injured  <  20
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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 distinct locations of perpetrators are there?
SQL: SELECT count(DISTINCT LOCATION) FROM perpetrator
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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: Show the date of the tallest perpetrator.
SQL: SELECT T2.Date FROM people AS T1 JOIN perpetrator AS T2 ON T1.People_ID  =  T2.People_ID ORDER BY T1.Height DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: perpetrator 
columns : [['perpetrator id', 'number'], ['people id', 'number'], ['date', 'text'], ['year', 'number'], ['location', 'text'], ['country', 'text'], ['killed', 'number'], ['injured', 'number']]

 -- Table: people 
columns : [['people id', 'number'], ['name', 'text'], ['height', 'number'], ['weight', 'number'], ['home town', '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: In which year did the most recent crime happen?
SQL: SELECT max(YEAR) FROM perpetrator;
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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: Report the name of all campuses in Los Angeles county.
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 campuses are located in the county of Los Angeles?
SQL: SELECT campus FROM campuses WHERE county  =  "Los Angeles"
-- Language PostgreSQL
        -- Tables: 
             -- Table: campuses 
columns : [['id', 'number'], ['campus', 'text'], ['location', 'text'], ['county', 'text'], ['year', 'number']]

 -- Table: csu fees 
columns : [['campus', 'number'], ['year', 'number'], ['campus fee', 'number']]

 -- Table: degrees 
columns : [['year', 'number'], ['campus', 'number'], ['degrees', 'number']]

 -- Table: discipline enrollments 
columns : [['campus', 'number'], ['discipline', 'number'], ['year', 'number'], ['undergraduate', 'number'], ['graduate', 'number']]

 -- Table: enrollments 
columns : [['campus', 'number'], ['year', 'number'], ['totalenrollment ay', 'number'], ['fte ay', 'number']]

 -- Table: faculty 
columns : [['campus', 'number'], ['year', 'number'], ['faculty', '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 all campuses located at Chico?
SQL: SELECT campus FROM campuses WHERE LOCATION  =  "Chico"