target-benchmark/spider-queries huggingface dataset:
Database: concert_singer (tables: singer)
Question: How many singers do we have?
SQL: SELECT count(*) FROM singer
Database: concert_singer (tables: singer)
Question: What is the total number of singers?
SQL: SELECT count(*) FROM singer
Database: concert_singer (tables: singer)
Question: Show name, country, age for all singers ordered by age from the oldest to the youngest.
SQL: SELECT name ,  country ,  age FROM singer ORDER BY age DESC
Database: concert_singer (tables: singer)
Question: What are the names, countries, and ages for every singer in descending order of age?
SQL: SELECT name ,  country ,  age FROM singer ORDER BY age DESC
Database: concert_singer (tables: singer)
Question: What is the average, minimum, and maximum age of all singers from France?
SQL: SELECT avg(age) ,  min(age) ,  max(age) FROM singer WHERE country  =  'France'
Database: concert_singer (tables: singer)
Question: What is the average, minimum, and maximum age for all French singers?
SQL: SELECT avg(age) ,  min(age) ,  max(age) FROM singer WHERE country  =  'France'
Database: concert_singer (tables: singer)
Question: Show the name and the release year of the song by the youngest singer.
SQL: SELECT song_name ,  song_release_year FROM singer ORDER BY age LIMIT 1
Database: concert_singer (tables: singer)
Question: What are the names and release years for all the songs of the youngest singer?
SQL: SELECT song_name ,  song_release_year FROM singer ORDER BY age LIMIT 1
Database: concert_singer (tables: singer)
Question: What are all distinct countries where singers above age 20 are from?
SQL: SELECT DISTINCT country FROM singer WHERE age  >  20
Database: concert_singer (tables: singer)
Question: What are  the different countries with singers above age 20?
SQL: SELECT DISTINCT country FROM singer WHERE age  >  20
Database: concert_singer (tables: singer)
Question: Show all countries and the number of singers in each country.
SQL: SELECT country ,  count(*) FROM singer GROUP BY country
Database: concert_singer (tables: singer)
Question: How many singers are from each country?
SQL: SELECT country ,  count(*) FROM singer GROUP BY country
Database: concert_singer (tables: singer)
Question: List all song names by singers above the average age.
SQL: SELECT song_name FROM singer WHERE age  >  (SELECT avg(age) FROM singer)
Database: concert_singer (tables: singer)
Question: What are all the song names by singers who are older than average?
SQL: SELECT song_name FROM singer WHERE age  >  (SELECT avg(age) FROM singer)
Database: concert_singer (tables: stadium)
Question: Show location and name for all stadiums with a capacity between 5000 and 10000.
SQL: SELECT LOCATION ,  name FROM stadium WHERE capacity BETWEEN 5000 AND 10000
Database: concert_singer (tables: stadium)
Question: What are the locations and names of all stations with capacity between 5000 and 10000?
SQL: SELECT LOCATION ,  name FROM stadium WHERE capacity BETWEEN 5000 AND 10000
Database: concert_singer (tables: stadium)
Question: What is the maximum capacity and the average of all stadiums ?
SQL: select max(capacity), average from stadium
Database: concert_singer (tables: stadium)
Question: What is the average and maximum capacities for all stadiums ?
SQL: select avg(capacity) ,  max(capacity) from stadium
Database: concert_singer (tables: stadium)
Question: What is the name and capacity for the stadium with highest average attendance?
SQL: SELECT name ,  capacity FROM stadium ORDER BY average DESC LIMIT 1
Database: concert_singer (tables: stadium)
Question: What is the name and capacity for the stadium with the highest average attendance?
SQL: SELECT name ,  capacity FROM stadium ORDER BY average DESC LIMIT 1
Database: concert_singer (tables: concert)
Question: How many concerts are there in year 2014 or 2015?
SQL: SELECT count(*) FROM concert WHERE YEAR  =  2014 OR YEAR  =  2015
Database: concert_singer (tables: concert)
Question: How many concerts occurred in 2014 or 2015?
SQL: SELECT count(*) FROM concert WHERE YEAR  =  2014 OR YEAR  =  2015
Database: concert_singer (tables: stadium, concert)
Question: Show the stadium name and the number of concerts in each stadium.
SQL: SELECT T2.name ,  count(*) FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id GROUP BY T1.stadium_id
Database: concert_singer (tables: stadium, concert)
Question: For each stadium, how many concerts play there?
SQL: SELECT T2.name ,  count(*) FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id GROUP BY T1.stadium_id
Database: concert_singer (tables: stadium, concert)
Question: Show the stadium name and capacity with most number of concerts in year 2014 or after.
SQL: SELECT T2.name ,  T2.capacity FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id WHERE T1.year  >=  2014 GROUP BY T2.stadium_id ORDER BY count(*) DESC LIMIT 1
Database: concert_singer (tables: stadium, concert)
Question: What is the name and capacity of the stadium with the most concerts after 2013 ?
SQL: select t2.name ,  t2.capacity from concert as t1 join stadium as t2 on t1.stadium_id  =  t2.stadium_id where t1.year  >  2013 group by t2.stadium_id order by count(*) desc limit 1
Database: concert_singer (tables: concert)
Question: Which year has most number of concerts?
SQL: SELECT YEAR FROM concert GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1
Database: concert_singer (tables: concert)
Question: What is the year that had the most concerts?
SQL: SELECT YEAR FROM concert GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1
Database: concert_singer (tables: stadium, concert)
Question: Show the stadium names without any concert.
SQL: SELECT name FROM stadium WHERE stadium_id NOT IN (SELECT stadium_id FROM concert)
Database: concert_singer (tables: stadium, concert)
Question: What are the names of the stadiums without any concerts?
SQL: SELECT name FROM stadium WHERE stadium_id NOT IN (SELECT stadium_id FROM concert)
Database: concert_singer (tables: singer)
Question: Show countries where a singer above age 40 and a singer below 30 are from.
SQL: SELECT country FROM singer WHERE age  >  40 INTERSECT SELECT country FROM singer WHERE age  <  30
Database: concert_singer (tables: stadium, concert)
Question: Show names for all stadiums except for stadiums having a concert in year 2014.
SQL: SELECT name FROM stadium EXCEPT SELECT T2.name FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id WHERE T1.year  =  2014
Database: concert_singer (tables: stadium, concert)
Question: What are the names of all stadiums that did not have a concert in 2014?
SQL: SELECT name FROM stadium EXCEPT SELECT T2.name FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id WHERE T1.year  =  2014
Database: concert_singer (tables: concert, singer_in_concert)
Question: Show the name and theme for all concerts and the number of singers in each concert.
SQL: SELECT T2.concert_name ,  T2.theme ,  count(*) FROM singer_in_concert AS T1 JOIN concert AS T2 ON T1.concert_id  =  T2.concert_id GROUP BY T2.concert_id
Database: concert_singer (tables: concert, singer_in_concert)
Question: What are the names , themes , and number of singers for every concert ?
SQL: select t2.concert_name ,  t2.theme ,  count(*) from singer_in_concert as t1 join concert as t2 on t1.concert_id  =  t2.concert_id group by t2.concert_id
Database: concert_singer (tables: singer, singer_in_concert)
Question: List singer names and number of concerts for each singer.
SQL: SELECT T2.name ,  count(*) FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id  =  T2.singer_id GROUP BY T2.singer_id
Database: concert_singer (tables: singer, singer_in_concert)
Question: What are the names of the singers and number of concerts for each person?
SQL: SELECT T2.name ,  count(*) FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id  =  T2.singer_id GROUP BY T2.singer_id
Database: concert_singer (tables: singer, concert, singer_in_concert)
Question: List all singer names in concerts in year 2014.
SQL: SELECT T2.name FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id  =  T2.singer_id JOIN concert AS T3 ON T1.concert_id  =  T3.concert_id WHERE T3.year  =  2014
Database: concert_singer (tables: singer, concert, singer_in_concert)
Question: What are the names of the singers who performed in a concert in 2014?
SQL: SELECT T2.name FROM singer_in_concert AS T1 JOIN singer AS T2 ON T1.singer_id  =  T2.singer_id JOIN concert AS T3 ON T1.concert_id  =  T3.concert_id WHERE T3.year  =  2014
Database: concert_singer (tables: singer)
Question: what is the name and nation of the singer who have a song having 'Hey' in its name?
SQL: SELECT name ,  country FROM singer WHERE song_name LIKE '%Hey%'
Database: concert_singer (tables: singer)
Question: What is the name and country of origin of every singer who has a song with the word 'Hey' in its title?
SQL: SELECT name ,  country FROM singer WHERE song_name LIKE '%Hey%'
Database: concert_singer (tables: stadium, concert)
Question: Find the name and location of the stadiums which some concerts happened in the years of both 2014 and 2015.
SQL: SELECT T2.name ,  T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id WHERE T1.Year  =  2014 INTERSECT SELECT T2.name ,  T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id WHERE T1.Year  =  2015
Database: concert_singer (tables: stadium, concert)
Question: What are the names and locations of the stadiums that had concerts that occurred in both 2014 and 2015?
SQL: SELECT T2.name ,  T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id WHERE T1.Year  =  2014 INTERSECT SELECT T2.name ,  T2.location FROM concert AS T1 JOIN stadium AS T2 ON T1.stadium_id  =  T2.stadium_id WHERE T1.Year  =  2015
Database: concert_singer (tables: stadium, concert)
Question: Find the number of concerts happened in the stadium with the highest capacity .
SQL: select count(*) from concert where stadium_id = (select stadium_id from stadium order by capacity desc limit 1)
Database: concert_singer (tables: stadium, concert)
Question: What are the number of concerts that occurred in the stadium with the largest capacity ?
SQL: select count(*) from concert where stadium_id = (select stadium_id from stadium order by capacity desc limit 1)
Database: pets_1 (tables: pets)
Question: Find the number of pets whose weight is heavier than 10.
SQL: SELECT count(*) FROM pets WHERE weight  >  10
Database: pets_1 (tables: pets)
Question: How many pets have a greater weight than 10?
SQL: SELECT count(*) FROM pets WHERE weight  >  10
Database: pets_1 (tables: pets)
Question: Find the weight of the youngest dog.
SQL: SELECT weight FROM pets ORDER BY pet_age LIMIT 1
Database: pets_1 (tables: pets)
Question: How much does the youngest dog weigh?
SQL: SELECT weight FROM pets ORDER BY pet_age LIMIT 1
Database: pets_1 (tables: pets)
Question: Find the maximum weight for each type of pet. List the maximum weight and pet type.
SQL: SELECT max(weight) ,  petType FROM pets GROUP BY petType
Database: pets_1 (tables: pets)
Question: List the maximum weight and type for each type of pet.
SQL: SELECT max(weight) ,  petType FROM pets GROUP BY petType
Database: pets_1 (tables: has_pet, student)
Question: Find number of pets owned by students who are older than 20.
SQL: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid WHERE T1.age  >  20
Database: pets_1 (tables: has_pet, student)
Question: How many pets are owned by students that have an age greater than 20?
SQL: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid WHERE T1.age  >  20
Database: pets_1 (tables: has_pet, pets, student)
Question: Find the number of dog pets that are raised by female students (with sex F).
SQL: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T2.petid  =  T3.petid WHERE T1.sex  =  'F' AND T3.pettype  =  'dog'
Database: pets_1 (tables: has_pet, pets, student)
Question: How many dog pets are raised by female students?
SQL: SELECT count(*) FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T2.petid  =  T3.petid WHERE T1.sex  =  'F' AND T3.pettype  =  'dog'
Database: pets_1 (tables: pets)
Question: Find the number of distinct type of pets.
SQL: SELECT count(DISTINCT pettype) FROM pets
Database: pets_1 (tables: pets)
Question: How many different types of pet are there?
SQL: SELECT count(DISTINCT pettype) FROM pets
Database: pets_1 (tables: has_pet, pets, student)
Question: Find the first name of students who have cat or dog pet.
SQL: SELECT DISTINCT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat' OR T3.pettype  =  'dog'
Database: pets_1 (tables: has_pet, pets, student)
Question: What are the first names of every student who has a cat or dog as a pet?
SQL: SELECT DISTINCT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat' OR T3.pettype  =  'dog'
Database: pets_1 (tables: has_pet, pets, student)
Question: Find the first name of students who have both cat and dog pets .
SQL: select t1.fname from student as t1 join has_pet as t2 on t1.stuid  =  t2.stuid join pets as t3 on t3.petid  =  t2.petid where t3.pettype  =  'cat' intersect select t1.fname from student as t1 join has_pet as t2 on t1.stuid  =  t2.stuid join pets as t3 on t3.petid  =  t2.petid where t3.pettype  =  'dog'
Database: pets_1 (tables: has_pet, pets, student)
Question: What are the students' first names who have both cats and dogs as pets?
SQL: SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat' INTERSECT SELECT T1.Fname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'dog'
Database: pets_1 (tables: has_pet, pets, student)
Question: Find the major and age of students who do not have a cat pet.
SQL: SELECT major ,  age FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat')
Database: pets_1 (tables: has_pet, pets, student)
Question: What major is every student who does not own a cat as a pet, and also how old are they?
SQL: SELECT major ,  age FROM student WHERE stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat')
Database: pets_1 (tables: has_pet, pets, student)
Question: Find the id of students who do not have a cat pet.
SQL: SELECT stuid FROM student EXCEPT SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat'
Database: pets_1 (tables: has_pet, pets, student)
Question: What are the ids of the students who do not own cats as pets?
SQL: SELECT stuid FROM student EXCEPT SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat'
Database: pets_1 (tables: has_pet, pets, student)
Question: Find the first name and age of students who have a dog but do not have a cat as a pet.
SQL: SELECT T1.fname ,  T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'dog' AND T1.stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat')
Database: pets_1 (tables: has_pet, pets, student)
Question: What is the first name of every student who has a dog but does not have a cat?
SQL: SELECT T1.fname ,  T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'dog' AND T1.stuid NOT IN (SELECT T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pettype  =  'cat')
Database: pets_1 (tables: pets)
Question: Find the type and weight of the youngest pet.
SQL: SELECT pettype ,  weight FROM pets ORDER BY pet_age LIMIT 1
Database: pets_1 (tables: pets)
Question: What type of pet is the youngest animal, and how much does it weigh?
SQL: SELECT pettype ,  weight FROM pets ORDER BY pet_age LIMIT 1
Database: pets_1 (tables: pets)
Question: Find the id and weight of all pets whose age is older than 1.
SQL: SELECT petid ,  weight FROM pets WHERE pet_age  >  1
Database: pets_1 (tables: pets)
Question: What is the id and weight of every pet who is older than 1?
SQL: SELECT petid ,  weight FROM pets WHERE pet_age  >  1
Database: pets_1 (tables: pets)
Question: Find the average and maximum age for each type of pet.
SQL: SELECT avg(pet_age) ,  max(pet_age) ,  pettype FROM pets GROUP BY pettype
Database: pets_1 (tables: pets)
Question: What is the average and maximum age for each pet type?
SQL: SELECT avg(pet_age) ,  max(pet_age) ,  pettype FROM pets GROUP BY pettype
Database: pets_1 (tables: pets)
Question: Find the average weight for each pet type.
SQL: SELECT avg(weight) ,  pettype FROM pets GROUP BY pettype
Database: pets_1 (tables: pets)
Question: What is the average weight for each type of pet?
SQL: SELECT avg(weight) ,  pettype FROM pets GROUP BY pettype
Database: pets_1 (tables: has_pet, student)
Question: Find the first name and age of students who have a pet.
SQL: SELECT DISTINCT T1.fname ,  T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid
Database: pets_1 (tables: has_pet, student)
Question: What are the different first names and ages of the students who do have pets?
SQL: SELECT DISTINCT T1.fname ,  T1.age FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid
Database: pets_1 (tables: has_pet, student)
Question: Find the id of the pet owned by student whose last name is ‘Smith’.
SQL: SELECT T2.petid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid WHERE T1.Lname  =  'Smith'
Database: pets_1 (tables: has_pet, student)
Question: What is the id of the pet owned by the student whose last name is 'Smith'?
SQL: SELECT T2.petid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid WHERE T1.Lname  =  'Smith'
Database: pets_1 (tables: has_pet, student)
Question: Find the number of pets for each student who has any pet and student id.
SQL: SELECT count(*) ,  T1.stuid FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid GROUP BY T1.stuid
Database: pets_1 (tables: has_pet, student)
Question: For students who have pets , how many pets does each student have ? list their ids instead of names .
SQL: select count(*) ,  t1.stuid from student as t1 join has_pet as t2 on t1.stuid  =  t2.stuid group by t1.stuid
Database: pets_1 (tables: has_pet, student)
Question: Find the first name and gender of student who have more than one pet.
SQL: SELECT T1.fname ,  T1.sex FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid GROUP BY T1.stuid HAVING count(*)  >  1
Database: pets_1 (tables: has_pet, student)
Question: What is the first name and gender of the all the students who have more than one pet?
SQL: SELECT T1.fname ,  T1.sex FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid GROUP BY T1.stuid HAVING count(*)  >  1
Database: pets_1 (tables: has_pet, pets, student)
Question: Find the last name of the student who has a cat that is age 3.
SQL: SELECT T1.lname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pet_age  =  3 AND T3.pettype  =  'cat'
Database: pets_1 (tables: has_pet, pets, student)
Question: What is the last name of the student who has a cat that is 3 years old?
SQL: SELECT T1.lname FROM student AS T1 JOIN has_pet AS T2 ON T1.stuid  =  T2.stuid JOIN pets AS T3 ON T3.petid  =  T2.petid WHERE T3.pet_age  =  3 AND T3.pettype  =  'cat'
Database: pets_1 (tables: has_pet, student)
Question: Find the average age of students who do not have any pet .
SQL: select avg(age) from student where stuid not in (select stuid from has_pet)
Database: pets_1 (tables: has_pet, student)
Question: What is the average age for all students who do not own any pets ?
SQL: select avg(age) from student where stuid not in (select stuid from has_pet)
Database: car_1 (tables: continents)
Question: How many continents are there?
SQL: SELECT count(*) FROM CONTINENTS;
Database: car_1 (tables: continents)
Question: What is the number of continents?
SQL: SELECT count(*) FROM CONTINENTS;
Database: car_1 (tables: countries, continents)
Question: How many countries does each continent have? List the continent id, continent name and the number of countries.
SQL: SELECT T1.ContId ,  T1.Continent ,  count(*) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId  =  T2.Continent GROUP BY T1.ContId;
Database: car_1 (tables: countries, continents)
Question: For each continent, list its id, name, and how many countries it has?
SQL: SELECT T1.ContId ,  T1.Continent ,  count(*) FROM CONTINENTS AS T1 JOIN COUNTRIES AS T2 ON T1.ContId  =  T2.Continent GROUP BY T1.ContId;
Database: car_1 (tables: countries)
Question: How many countries are listed?
SQL: SELECT count(*) FROM COUNTRIES;
Database: car_1 (tables: countries)
Question: How many countries exist?
SQL: SELECT count(*) FROM COUNTRIES;
Database: car_1 (tables: model_list, car_makers)
Question: How many models does each car maker produce? List maker full name, id and the number.
SQL: SELECT T1.FullName ,  T1.Id ,  count(*) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id  =  T2.Maker GROUP BY T1.Id;
Database: car_1 (tables: model_list, car_makers)
Question: What is the full name of each car maker, along with its id and how many models it produces?
SQL: SELECT T1.FullName ,  T1.Id ,  count(*) FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id  =  T2.Maker GROUP BY T1.Id;
Database: car_1 (tables: cars_data, car_names)
Question: Which model of the car has the minimum horsepower?
SQL: SELECT T1.Model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId  =  T2.Id ORDER BY T2.horsepower ASC LIMIT 1;
Database: car_1 (tables: cars_data, car_names)
Question: What is the model of the car with the smallest amount of horsepower?
SQL: SELECT T1.Model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId  =  T2.Id ORDER BY T2.horsepower ASC LIMIT 1;
Database: car_1 (tables: car_names, cars_data)
Question: Find the model of the car whose weight is below the average weight.
SQL: SELECT T1.model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId  =  T2.Id WHERE T2.Weight  <  (SELECT avg(Weight) FROM CARS_DATA)
Database: car_1 (tables: car_names, cars_data)
Question: What is the model for the car with a weight smaller than the average?
SQL: SELECT T1.model FROM CAR_NAMES AS T1 JOIN CARS_DATA AS T2 ON T1.MakeId  =  T2.Id WHERE T2.Weight  <  (SELECT avg(Weight) FROM CARS_DATA)
Database: car_1 (tables: car_names, model_list, car_makers, cars_data)
Question: Find the name of the makers that produced some cars in the year of 1970?
SQL: SELECT DISTINCT T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id  =  T2.Maker JOIN CAR_NAMES AS T3 ON T2.model  =  T3.model JOIN CARS_DATA AS T4 ON T3.MakeId  =  T4.id WHERE T4.year  =  '1970';
Database: car_1 (tables: car_names, model_list, car_makers, cars_data)
Question: What is the name of the different car makers who produced a car in 1970?
SQL: SELECT DISTINCT T1.Maker FROM CAR_MAKERS AS T1 JOIN MODEL_LIST AS T2 ON T1.Id  =  T2.Maker JOIN CAR_NAMES AS T3 ON T2.model  =  T3.model JOIN CARS_DATA AS T4 ON T3.MakeId  =  T4.id WHERE T4.year  =  '1970';
Database: car_1 (tables: car_names, cars_data)
Question: Find the make and production time of the cars that were produced in the earliest year?
SQL: SELECT T2.Make ,  T1.Year FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id  =  T2.MakeId WHERE T1.Year  =  (SELECT min(YEAR) FROM CARS_DATA);
Database: car_1 (tables: car_names, cars_data)
Question: What is the maker of the carr produced in the earliest year and what year was it?
SQL: SELECT T2.Make ,  T1.Year FROM CARS_DATA AS T1 JOIN CAR_NAMES AS T2 ON T1.Id  =  T2.MakeId WHERE T1.Year  =  (SELECT min(YEAR) FROM CARS_DATA);