sert121/SpiderSQL huggingface dataset:
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 ids of stations that have latitude above 37.4 and never had bike availability below 7?
SQL: SELECT id FROM station WHERE lat  >  37.4 EXCEPT SELECT station_id FROM status GROUP BY station_id HAVING min(bikes_available)  <  7
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 ids of all stations that have a latitude above 37.4 and have never had less than 7 bikes available?
SQL: SELECT id FROM station WHERE lat  >  37.4 EXCEPT SELECT station_id FROM status GROUP BY station_id HAVING min(bikes_available)  <  7
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 names of stations that have average bike availability above 10 and are not located in San Jose city?
SQL: SELECT T1.name FROM station AS T1 JOIN status AS T2 ON T1.id  =  T2.station_id GROUP BY T2.station_id HAVING avg(bikes_available)  >  10 EXCEPT SELECT name FROM station WHERE city  =  "San Jose"
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 stations that have more than 10 bikes available and are not located in San Jose?
SQL: SELECT T1.name FROM station AS T1 JOIN status AS T2 ON T1.id  =  T2.station_id GROUP BY T2.station_id HAVING avg(bikes_available)  >  10 EXCEPT SELECT name FROM station WHERE city  =  "San Jose"
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 name, latitude, and city of the station with the lowest latitude?
SQL: SELECT name ,  lat ,  city FROM station ORDER BY lat LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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, latitude, and city of the station that is located the furthest South?
SQL: SELECT name ,  lat ,  city FROM station ORDER BY lat LIMIT 1
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 date, mean temperature and mean humidity for the top 3 days with the largest max gust speeds?
SQL: SELECT date ,  mean_temperature_f ,  mean_humidity FROM weather ORDER BY max_gust_speed_mph DESC LIMIT 3
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 date, average temperature and mean humidity for the days with the 3 largest maximum gust speeds?
SQL: SELECT date ,  mean_temperature_f ,  mean_humidity FROM weather ORDER BY max_gust_speed_mph DESC LIMIT 3
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', 'number']]

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



Question: List the name and the number of stations for all the cities that have at least 15 stations.
SQL: SELECT city ,  COUNT(*) FROM station GROUP BY city HAVING COUNT(*)  >=  15
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 every city that has at least 15 stations and how many stations does it have?
SQL: SELECT city ,  COUNT(*) FROM station GROUP BY city HAVING COUNT(*)  >=  15
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', 'number']]

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



Question: Find the ids and names of stations from which at least 200 trips started.
SQL: SELECT start_station_id ,  start_station_name FROM trip GROUP BY start_station_name HAVING COUNT(*)  >=  200
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 ids and names of all start stations that were the beginning of at least 200 trips?
SQL: SELECT start_station_id ,  start_station_name FROM trip GROUP BY start_station_name HAVING COUNT(*)  >=  200
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', 'number']]

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



Question: Find the zip code in which the average mean visibility is lower than 10.
SQL: SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_visibility_miles)  <  10
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 zip code, select all those that have an average mean visiblity below 10.
SQL: SELECT zip_code FROM weather GROUP BY zip_code HAVING avg(mean_visibility_miles)  <  10
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 all the cities in a decreasing order of each city's stations' highest latitude.
SQL: SELECT city FROM station GROUP BY city ORDER BY max(lat) DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 city, list their names in decreasing order by their highest station latitude.
SQL: SELECT city FROM station GROUP BY city ORDER BY max(lat) DESC
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 dates that had the top 5 cloud cover rates? Also tell me the cloud cover rate.
SQL: SELECT date ,  cloud_cover FROM weather ORDER BY cloud_cover DESC LIMIT 5
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 dates that have the 5 highest cloud cover rates and what are the rates?
SQL: SELECT date ,  cloud_cover FROM weather ORDER BY cloud_cover DESC LIMIT 5
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 ids and durations of the trips with the top 3 durations?
SQL: SELECT id ,  duration FROM trip ORDER BY duration DESC LIMIT 3
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 ids of the trips that lasted the longest and how long did they last?
SQL: SELECT id ,  duration FROM trip ORDER BY duration DESC LIMIT 3
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 station, return its longitude and the average duration of trips that started from the station.
SQL: SELECT T1.name ,  T1.long ,  avg(T2.duration) FROM station AS T1 JOIN trip AS T2 ON T1.id  =  T2.start_station_id GROUP BY T2.start_station_id
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 start station id, what is its name, longitude and average duration of trips started there?
SQL: SELECT T1.name ,  T1.long ,  avg(T2.duration) FROM station AS T1 JOIN trip AS T2 ON T1.id  =  T2.start_station_id GROUP BY T2.start_station_id
-- Language PostgreSQL
        -- Tables: 
             -- Table: station 
columns : [['id', 'number'], ['name', 'text'], ['latitude', 'number'], ['longitude', 'number'], ['dock count', 'number'], ['city', 'text'], ['installation date', 'text']]

 -- Table: status 
columns : [['station id', 'number'], ['bikes available', 'number'], ['docks available', 'number'], ['time', 'text']]

 -- Table: trip 
columns : [['id', 'number'], ['duration', 'number'], ['start date', 'text'], ['start station name', 'text'], ['start station id', 'number'], ['end date', 'text'], ['end station name', 'text'], ['end station id', 'number'], ['bike id', 'number'], ['subscription type', 'text'], ['zip code', 'number']]

 -- Table: weather 
columns : [['date', 'text'], ['max temperature f', 'number'], ['mean temperature f', 'number'], ['min temperature f', 'number'], ['max dew point f', 'number'], ['mean dew point f', 'number'], ['min dew point f', 'number'], ['max humidity', 'number'], ['mean humidity', 'number'], ['min humidity', 'number'], ['max sea level pressure inches', 'number'], ['mean sea level pressure inches', 'number'], ['min sea level pressure inches', 'number'], ['max visibility miles', 'number'], ['mean visibility miles', 'number'], ['min visibility miles', 'number'], ['max wind speed mph', 'number'], ['mean wind speed mph', 'number'], ['max gust speed mph', 'number'], ['precipitation inches', 'number'], ['cloud cover', 'number'], ['events', 'text'], ['wind dir degrees', 'number'], ['zip code', '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 station, find its latitude and the minimum duration of trips that ended at the station.
SQL: SELECT T1.name ,  T1.lat ,  min(T2.duration) FROM station AS T1 JOIN trip AS T2 ON T1.id  =  T2.end_station_id GROUP BY T2.end_station_id