sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: circuits 
columns : [['circuit id', 'number'], ['circuit reference', 'text'], ['name', 'text'], ['location', 'text'], ['country', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['altitude', 'number'], ['url', 'text']]

 -- Table: races 
columns : [['race id', 'number'], ['year', 'number'], ['round', 'number'], ['circuit id', 'number'], ['name', 'text'], ['date', 'text'], ['time', 'text'], ['url', 'text']]

 -- Table: drivers 
columns : [['driver id', 'number'], ['driver reference', 'text'], ['number', 'number'], ['code', 'text'], ['forename', 'text'], ['surname', 'text'], ['dob', 'text'], ['nationality', 'text'], ['url', 'text']]

 -- Table: status 
columns : [['status id', 'number'], ['status', 'text']]

 -- Table: seasons 
columns : [['year', 'number'], ['url', 'text']]

 -- Table: constructors 
columns : [['constructor id', 'number'], ['constructor reference', 'text'], ['name', 'text'], ['nationality', 'text'], ['url', 'text']]

 -- Table: constructor standings 
columns : [['constructor standings id', 'number'], ['race id', 'number'], ['constructor id', 'number'], ['points', 'number'], ['position', 'number'], ['position text', 'text'], ['wins', 'number']]

 -- Table: results 
columns : [['result id', 'number'], ['race id', 'number'], ['driver id', 'number'], ['constructor id', 'number'], ['number', 'number'], ['grid', 'number'], ['position', 'number'], ['position text', 'text'], ['position order', 'number'], ['points', 'number'], ['laps', 'number'], ['time', 'text'], ['milliseconds', 'number'], ['fastest lap', 'number'], ['rank', 'number'], ['fastest lap time', 'text'], ['fastest lap speed', 'text'], ['status id', 'number']]

 -- Table: driver standings 
columns : [['driver standings id', 'number'], ['race id', 'number'], ['driver id', 'number'], ['points', 'number'], ['position', 'number'], ['position text', 'text'], ['wins', 'number']]

 -- Table: constructor results 
columns : [['constructor results id', 'number'], ['race id', 'number'], ['constructor id', 'number'], ['points', 'number'], ['status', 'number']]

 -- Table: qualifying 
columns : [['qualify id', 'number'], ['race id', 'number'], ['driver id', 'number'], ['constructor id', 'number'], ['number', 'number'], ['position', 'number'], ['q1', 'text'], ['q2', 'text'], ['q3', 'text']]

 -- Table: pit stops 
columns : [['race id', 'number'], ['driver id', 'number'], ['stop', 'number'], ['lap', 'number'], ['time', 'text'], ['duration', 'text'], ['milliseconds', 'number']]

 -- Table: lap times 
columns : [['race id', 'number'], ['driver id', 'number'], ['lap', 'number'], ['position', 'number'], ['time', 'text'], ['milliseconds', '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 circuits that belong to UK or Malaysia?
SQL: SELECT name FROM circuits WHERE country = "UK" OR country = "Malaysia"
-- Language PostgreSQL
        -- Tables: 
             -- Table: circuits 
columns : [['circuit id', 'number'], ['circuit reference', 'text'], ['name', 'text'], ['location', 'text'], ['country', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['altitude', 'number'], ['url', 'text']]

 -- Table: races 
columns : [['race id', 'number'], ['year', 'number'], ['round', 'number'], ['circuit id', 'number'], ['name', 'text'], ['date', 'text'], ['time', 'text'], ['url', 'text']]

 -- Table: drivers 
columns : [['driver id', 'number'], ['driver reference', 'text'], ['number', 'number'], ['code', 'text'], ['forename', 'text'], ['surname', 'text'], ['dob', 'text'], ['nationality', 'text'], ['url', 'text']]

 -- Table: status 
columns : [['status id', 'number'], ['status', 'text']]

 -- Table: seasons 
columns : [['year', 'number'], ['url', 'text']]

 -- Table: constructors 
columns : [['constructor id', 'number'], ['constructor reference', 'text'], ['name', 'text'], ['nationality', 'text'], ['url', 'text']]

 -- Table: constructor standings 
columns : [['constructor standings id', 'number'], ['race id', 'number'], ['constructor id', 'number'], ['points', 'number'], ['position', 'number'], ['position text', 'text'], ['wins', 'number']]

 -- Table: results 
columns : [['result id', 'number'], ['race id', 'number'], ['driver id', 'number'], ['constructor id', 'number'], ['number', 'number'], ['grid', 'number'], ['position', 'number'], ['position text', 'text'], ['position order', 'number'], ['points', 'number'], ['laps', 'number'], ['time', 'text'], ['milliseconds', 'number'], ['fastest lap', 'number'], ['rank', 'number'], ['fastest lap time', 'text'], ['fastest lap speed', 'text'], ['status id', 'number']]

 -- Table: driver standings 
columns : [['driver standings id', 'number'], ['race id', 'number'], ['driver id', 'number'], ['points', 'number'], ['position', 'number'], ['position text', 'text'], ['wins', 'number']]

 -- Table: constructor results 
columns : [['constructor results id', 'number'], ['race id', 'number'], ['constructor id', 'number'], ['points', 'number'], ['status', 'number']]

 -- Table: qualifying 
columns : [['qualify id', 'number'], ['race id', 'number'], ['driver id', 'number'], ['constructor id', 'number'], ['number', 'number'], ['position', 'number'], ['q1', 'text'], ['q2', 'text'], ['q3', 'text']]

 -- Table: pit stops 
columns : [['race id', 'number'], ['driver id', 'number'], ['stop', 'number'], ['lap', 'number'], ['time', 'text'], ['duration', 'text'], ['milliseconds', 'number']]

 -- Table: lap times 
columns : [['race id', 'number'], ['driver id', 'number'], ['lap', 'number'], ['position', 'number'], ['time', 'text'], ['milliseconds', '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 the circuits that are in the UK or Malaysia?
SQL: SELECT name FROM circuits WHERE country = "UK" OR country = "Malaysia"
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians are there?
SQL: SELECT count(*) FROM technician
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 number of technicians?
SQL: SELECT count(*) FROM technician
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians in ascending order of age.
SQL: SELECT Name FROM technician ORDER BY Age ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians by ascending order of age?
SQL: SELECT Name FROM technician ORDER BY Age ASC
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 team and starting year of technicians?
SQL: SELECT Team ,  Starting_Year FROM technician
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 team and starting year for each technician?
SQL: SELECT Team ,  Starting_Year FROM technician
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 name of technicians whose team is not "NYY".
SQL: SELECT Name FROM technician WHERE Team != "NYY"
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technician whose team is not 'NYY'?
SQL: SELECT Name FROM technician WHERE Team != "NYY"
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 name of technicians aged either 36 or 37
SQL: SELECT Name FROM technician WHERE Age  =  36 OR Age  =  37
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians aged either 36 or 37?
SQL: SELECT Name FROM technician WHERE Age  =  36 OR Age  =  37
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 starting year of the oldest technicians?
SQL: SELECT Starting_Year FROM technician ORDER BY Age DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 starting year for the oldest technician?
SQL: SELECT Starting_Year FROM technician ORDER BY Age DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 different teams of technicians and the number of technicians in each team.
SQL: SELECT Team ,  COUNT(*) FROM technician GROUP BY Team
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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: For each team, how many technicians are there?
SQL: SELECT Team ,  COUNT(*) FROM technician GROUP BY Team
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 team that has the most number of technicians.
SQL: SELECT Team FROM technician GROUP BY Team ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 teams with the most technicians?
SQL: SELECT Team FROM technician GROUP BY Team ORDER BY COUNT(*) DESC LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 team that have at least two technicians.
SQL: SELECT Team FROM technician GROUP BY Team HAVING COUNT(*)  >=  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 team with at least 2 technicians?
SQL: SELECT Team FROM technician GROUP BY Team HAVING COUNT(*)  >=  2
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians and series of machines they are assigned to repair.
SQL: SELECT T3.Name ,  T2.Machine_series FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians and the machine series that they repair?
SQL: SELECT T3.Name ,  T2.Machine_series FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians in ascending order of quality rank of the machine they are assigned.
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID ORDER BY T2.quality_rank
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians by ascending order of quality rank for the machine they are assigned?
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID ORDER BY T2.quality_rank
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians who are assigned to repair machines with value point more than 70.
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID WHERE T2.value_points  >  70
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians that are assigned to repair machines with more point values than 70?
SQL: SELECT T3.Name FROM repair_assignment AS T1 JOIN machine AS T2 ON T1.machine_id  =  T2.machine_id JOIN technician AS T3 ON T1.technician_ID  =  T3.technician_ID WHERE T2.value_points  >  70
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians and the number of machines they are assigned to repair.
SQL: SELECT T2.Name ,  COUNT(*) FROM repair_assignment AS T1 JOIN technician AS T2 ON T1.technician_ID  =  T2.technician_ID GROUP BY T2.Name
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians  and how many machines are they assigned to repair?
SQL: SELECT T2.Name ,  COUNT(*) FROM repair_assignment AS T1 JOIN technician AS T2 ON T1.technician_ID  =  T2.technician_ID GROUP BY T2.Name
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians who have not been assigned to repair machines.
SQL: SELECT Name FROM technician WHERE technician_id NOT IN (SELECT technician_id FROM repair_assignment)
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 technicians that have not been assigned to repair machines?
SQL: SELECT Name FROM technician WHERE technician_id NOT IN (SELECT technician_id FROM repair_assignment)
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 starting years shared by technicians from team "CLE" and "CWS".
SQL: SELECT Starting_Year FROM technician WHERE Team  =  "CLE" INTERSECT SELECT Starting_Year FROM technician WHERE Team  =  "CWS"
-- Language PostgreSQL
        -- Tables: 
             -- Table: repair 
columns : [['repair id', 'number'], ['name', 'text'], ['launch date', 'text'], ['notes', 'text']]

 -- Table: machine 
columns : [['machine id', 'number'], ['making year', 'number'], ['class', 'text'], ['team', 'text'], ['machine series', 'text'], ['value points', 'number'], ['quality rank', 'number']]

 -- Table: technician 
columns : [['technician id', 'number'], ['name', 'text'], ['team', 'text'], ['starting year', 'number'], ['age', 'number']]

 -- Table: repair assignment 
columns : [['technician id', 'number'], ['repair id', 'number'], ['machine 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 starting years shared by the technicians from the team "CLE" or "CWS"?
SQL: SELECT Starting_Year FROM technician WHERE Team  =  "CLE" INTERSECT SELECT Starting_Year FROM technician WHERE Team  =  "CWS"
-- 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 are there?
SQL: SELECT count(*) 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 entrepreneurs.
SQL: SELECT count(*) 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: List the companies of entrepreneurs in descending order of money requested.
SQL: SELECT Company FROM entrepreneur ORDER BY 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 companies of entrepreneurs, ordered descending by amount of money requested?
SQL: SELECT Company FROM entrepreneur ORDER BY 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: List the companies and the investors of entrepreneurs.
SQL: SELECT Company ,  Investor 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 companies and investors that correspond to each entrepreneur?
SQL: SELECT Company ,  Investor 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 is the average money requested by all entrepreneurs?
SQL: SELECT avg(Money_Requested) 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: Return the average money requested across all entrepreneurs.
SQL: SELECT avg(Money_Requested) 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 in ascending order of weight?
SQL: SELECT Name FROM People ORDER BY Weight ASC
-- 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 people, ordered by weight ascending.
SQL: SELECT Name FROM People ORDER BY Weight ASC