target-benchmark/spider-queries huggingface dataset:
Database: driving_school (tables: staff, lessons)
Question: What is the first name of the staff who did not give any lesson?
SQL: SELECT first_name FROM Staff EXCEPT SELECT T2.first_name FROM Lessons AS T1 JOIN Staff AS T2 ON T1.staff_id  =  T2.staff_id
Database: driving_school (tables: staff, lessons)
Question: What is the first name of all employees who do not give any lessons?
SQL: SELECT first_name FROM Staff EXCEPT SELECT T2.first_name FROM Lessons AS T1 JOIN Staff AS T2 ON T1.staff_id  =  T2.staff_id
Database: driving_school (tables: vehicles, lessons)
Question: What is the id and detail of the vehicle used in lessons for most of the times?
SQL: SELECT T1.vehicle_id ,  T1.vehicle_details FROM Vehicles AS T1 JOIN Lessons AS T2 ON T1.vehicle_id  =  T2.vehicle_id GROUP BY T1.vehicle_id ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: faculty)
Question: How many faculty do we have?
SQL: SELECT count(*) FROM Faculty
Database: activity_1 (tables: faculty)
Question: What is the total number of faculty members?
SQL: SELECT count(*) FROM Faculty
Database: activity_1 (tables: faculty)
Question: What ranks do we have for faculty?
SQL: SELECT DISTINCT rank FROM Faculty
Database: activity_1 (tables: faculty)
Question: Find the list of distinct ranks for faculty.
SQL: SELECT DISTINCT rank FROM Faculty
Database: activity_1 (tables: faculty)
Question: Show all the distinct buildings that have faculty rooms.
SQL: SELECT DISTINCT building FROM Faculty
Database: activity_1 (tables: faculty)
Question: What buildings have faculty offices?
SQL: SELECT DISTINCT building FROM Faculty
Database: activity_1 (tables: faculty)
Question: Show the rank, first name, and last name for all the faculty.
SQL: SELECT rank ,  Fname ,  Lname FROM Faculty
Database: activity_1 (tables: faculty)
Question: What are the rank, first name, and last name of the faculty members?
SQL: SELECT rank ,  Fname ,  Lname FROM Faculty
Database: activity_1 (tables: faculty)
Question: Show the first name, last name, and phone number for all female faculty members.
SQL: SELECT Fname ,  Lname ,  phone FROM Faculty WHERE Sex  =  'F'
Database: activity_1 (tables: faculty)
Question: What are the first name, last name, and phone number of all the female faculty members?
SQL: SELECT Fname ,  Lname ,  phone FROM Faculty WHERE Sex  =  'F'
Database: activity_1 (tables: faculty)
Question: Show ids for all the male faculty.
SQL: SELECT FacID FROM Faculty WHERE Sex  =  'M'
Database: activity_1 (tables: faculty)
Question: What are the faculty ids of all the male faculty members?
SQL: SELECT FacID FROM Faculty WHERE Sex  =  'M'
Database: activity_1 (tables: faculty)
Question: How many female Professors do we have?
SQL: SELECT count(*) FROM Faculty WHERE Sex  =  'F' AND Rank  =  "Professor"
Database: activity_1 (tables: faculty)
Question: Count the number of female Professors we have.
SQL: SELECT count(*) FROM Faculty WHERE Sex  =  'F' AND Rank  =  "Professor"
Database: activity_1 (tables: faculty)
Question: Show the phone, room, and building for the faculty named Jerry Prince.
SQL: SELECT phone ,  room ,  building FROM Faculty WHERE Fname  =  "Jerry" AND Lname  =  "Prince"
Database: activity_1 (tables: faculty)
Question: What are the phone, room, and building of the faculty member called Jerry Prince?
SQL: SELECT phone ,  room ,  building FROM Faculty WHERE Fname  =  "Jerry" AND Lname  =  "Prince"
Database: activity_1 (tables: faculty)
Question: How many Professors are in building NEB?
SQL: SELECT count(*) FROM Faculty WHERE Rank  =  "Professor" AND building  =  "NEB"
Database: activity_1 (tables: faculty)
Question: Count the number of Professors who have office in building NEB.
SQL: SELECT count(*) FROM Faculty WHERE Rank  =  "Professor" AND building  =  "NEB"
Database: activity_1 (tables: faculty)
Question: Show the first name and last name for all the instructors.
SQL: SELECT fname ,  lname FROM Faculty WHERE Rank  =  "Instructor"
Database: activity_1 (tables: faculty)
Question: What are the first name and last name of all the instructors?
SQL: SELECT fname ,  lname FROM Faculty WHERE Rank  =  "Instructor"
Database: activity_1 (tables: faculty)
Question: Show all the buildings along with the number of faculty members the buildings have.
SQL: SELECT building ,  count(*) FROM Faculty GROUP BY building
Database: activity_1 (tables: faculty)
Question: How many faculty members does each building have? List the result with the name of the building.
SQL: SELECT building ,  count(*) FROM Faculty GROUP BY building
Database: activity_1 (tables: faculty)
Question: Which building has most faculty members?
SQL: SELECT building FROM Faculty GROUP BY building ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: faculty)
Question: Find the building that has the largest number of faculty members.
SQL: SELECT building FROM Faculty GROUP BY building ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: faculty)
Question: Show all the buildings that have at least 10 professors.
SQL: SELECT building FROM Faculty WHERE rank  =  "Professor" GROUP BY building HAVING count(*)  >=  10
Database: activity_1 (tables: faculty)
Question: In which buildings are there at least ten professors?
SQL: SELECT building FROM Faculty WHERE rank  =  "Professor" GROUP BY building HAVING count(*)  >=  10
Database: activity_1 (tables: faculty)
Question: For each faculty rank, show the number of faculty members who have it.
SQL: SELECT rank ,  count(*) FROM Faculty GROUP BY rank
Database: activity_1 (tables: faculty)
Question: How many faculty members do we have for each faculty rank?
SQL: SELECT rank ,  count(*) FROM Faculty GROUP BY rank
Database: activity_1 (tables: faculty)
Question: Show all the ranks and the number of male and female faculty for each rank.
SQL: SELECT rank ,  sex ,  count(*) FROM Faculty GROUP BY rank ,  sex
Database: activity_1 (tables: faculty)
Question: How many faculty members do we have for each rank and gender?
SQL: SELECT rank ,  sex ,  count(*) FROM Faculty GROUP BY rank ,  sex
Database: activity_1 (tables: faculty)
Question: Which rank has the smallest number of faculty members?
SQL: SELECT rank FROM Faculty GROUP BY rank ORDER BY count(*) ASC LIMIT 1
Database: activity_1 (tables: faculty)
Question: Find the faculty rank that has the least members.
SQL: SELECT rank FROM Faculty GROUP BY rank ORDER BY count(*) ASC LIMIT 1
Database: activity_1 (tables: faculty)
Question: Show the number of male and female assistant professors.
SQL: SELECT sex ,  count(*) FROM Faculty WHERE rank  =  "AsstProf" GROUP BY sex
Database: activity_1 (tables: faculty)
Question: How many male and female assistant professors do we have?
SQL: SELECT sex ,  count(*) FROM Faculty WHERE rank  =  "AsstProf" GROUP BY sex
Database: activity_1 (tables: student, faculty)
Question: What are the first name and last name of Linda Smith's advisor?
SQL: SELECT T1.fname ,  T1.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T2.fname  =  "Linda" AND T2.lname  =  "Smith"
Database: activity_1 (tables: student, faculty)
Question: Who is the advisor of Linda Smith? Give me the first name and last name.
SQL: SELECT T1.fname ,  T1.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T2.fname  =  "Linda" AND T2.lname  =  "Smith"
Database: activity_1 (tables: student, faculty)
Question: Show the ids of students whose advisors are professors.
SQL: SELECT T2.StuID FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T1.rank  =  "Professor"
Database: activity_1 (tables: student, faculty)
Question: Which students have professors as their advisors? Find their student ids.
SQL: SELECT T2.StuID FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T1.rank  =  "Professor"
Database: activity_1 (tables: student, faculty)
Question: Show first name and last name for all the students advised by Michael Goodrich.
SQL: SELECT T2.fname ,  T2.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T1.fname  =  "Michael" AND T1.lname  =  "Goodrich"
Database: activity_1 (tables: student, faculty)
Question: Which students are advised by Michael Goodrich? Give me their first and last names.
SQL: SELECT T2.fname ,  T2.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor WHERE T1.fname  =  "Michael" AND T1.lname  =  "Goodrich"
Database: activity_1 (tables: student, faculty)
Question: Show the faculty id of each faculty member, along with the number of students he or she advises.
SQL: SELECT T1.FacID ,  count(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.FacID
Database: activity_1 (tables: student, faculty)
Question: What are the faculty id and the number of students each faculty has?
SQL: SELECT T1.FacID ,  count(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.FacID
Database: activity_1 (tables: student, faculty)
Question: Show all the faculty ranks and the number of students advised by each rank.
SQL: SELECT T1.rank ,  count(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.rank
Database: activity_1 (tables: student, faculty)
Question: How many students are advised by each rank of faculty? List the rank and the number of students.
SQL: SELECT T1.rank ,  count(*) FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.rank
Database: activity_1 (tables: student, faculty)
Question: What are the first and last name of the faculty who has the most students?
SQL: SELECT T1.fname ,  T1.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.FacID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: student, faculty)
Question: Give me the the first and last name of the faculty who advises the most students.
SQL: SELECT T1.fname ,  T1.lname FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.FacID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: student, faculty)
Question: Show the ids for all the faculty members who have at least 2 students.
SQL: SELECT T1.FacID FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.FacID HAVING count(*)  >=  2
Database: activity_1 (tables: student, faculty)
Question: Which faculty members advise two ore more students? Give me their faculty ids.
SQL: SELECT T1.FacID FROM Faculty AS T1 JOIN Student AS T2 ON T1.FacID  =  T2.advisor GROUP BY T1.FacID HAVING count(*)  >=  2
Database: activity_1 (tables: student, faculty)
Question: Show ids for the faculty members who don't advise any student.
SQL: SELECT FacID FROM Faculty EXCEPT SELECT advisor FROM Student
Database: activity_1 (tables: student, faculty)
Question: What are the ids of the faculty members who do not advise any student.
SQL: SELECT FacID FROM Faculty EXCEPT SELECT advisor FROM Student
Database: activity_1 (tables: activity)
Question: What activities do we have?
SQL: SELECT activity_name FROM Activity
Database: activity_1 (tables: activity)
Question: List all the activities we have.
SQL: SELECT activity_name FROM Activity
Database: activity_1 (tables: activity)
Question: How many activities do we have?
SQL: SELECT count(*) FROM Activity
Database: activity_1 (tables: activity)
Question: Find the number of activities available.
SQL: SELECT count(*) FROM Activity
Database: activity_1 (tables: faculty_participates_in)
Question: How many faculty members participate in an activity?
SQL: SELECT count(DISTINCT FacID) FROM Faculty_participates_in
Database: activity_1 (tables: faculty_participates_in)
Question: Give me the number of faculty members who participate in an activity
SQL: SELECT count(DISTINCT FacID) FROM Faculty_participates_in
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: Show the ids of the faculty who don't participate in any activity.
SQL: SELECT FacID FROM Faculty EXCEPT SELECT FacID FROM Faculty_participates_in
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: Which faculty do not participate in any activity? Find their faculty ids.
SQL: SELECT FacID FROM Faculty EXCEPT SELECT FacID FROM Faculty_participates_in
Database: activity_1 (tables: faculty_participates_in, student)
Question: Show the ids of all the faculty members who participate in an activity and advise a student.
SQL: SELECT FacID FROM Faculty_participates_in INTERSECT SELECT advisor FROM Student
Database: activity_1 (tables: faculty_participates_in, student)
Question: What are ids of the faculty members who not only participate in an activity but also advise a student.
SQL: SELECT FacID FROM Faculty_participates_in INTERSECT SELECT advisor FROM Student
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: How many activities does Mark Giuliano participate in?
SQL: SELECT count(*) FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID WHERE T1.fname  =  "Mark" AND T1.lname  =  "Giuliano"
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: Find the number of activities Mark Giuliano is involved in.
SQL: SELECT count(*) FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID WHERE T1.fname  =  "Mark" AND T1.lname  =  "Giuliano"
Database: activity_1 (tables: faculty_participates_in, activity, faculty)
Question: Show the names of all the activities Mark Giuliano participates in.
SQL: SELECT T3.activity_name FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN Activity AS T3 ON T3.actid  =  T2.actid WHERE T1.fname  =  "Mark" AND T1.lname  =  "Giuliano"
Database: activity_1 (tables: faculty_participates_in, activity, faculty)
Question: What are the names of the activities Mark Giuliano is involved in
SQL: SELECT T3.activity_name FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN Activity AS T3 ON T3.actid  =  T2.actid WHERE T1.fname  =  "Mark" AND T1.lname  =  "Giuliano"
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: Show the first and last name of all the faculty members who participated in some activity, together with the number of activities they participated in.
SQL: SELECT  T1.fname ,  T1.lname ,  count(*) ,  T1.FacID FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID GROUP BY T1.FacID
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: What is the first and last name of the faculty members who participated in at least one activity? For each of them, also show the number of activities they participated in.
SQL: SELECT  T1.fname ,  T1.lname ,  count(*) ,  T1.FacID FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID GROUP BY T1.FacID
Database: activity_1 (tables: faculty_participates_in, activity)
Question: Show all the activity names and the number of faculty involved in each activity.
SQL: SELECT T1.activity_name ,  count(*) FROM Activity AS T1 JOIN Faculty_participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID
Database: activity_1 (tables: faculty_participates_in, activity)
Question: How many faculty members participate in each activity? Return the activity names and the number of faculty members.
SQL: SELECT T1.activity_name ,  count(*) FROM Activity AS T1 JOIN Faculty_participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: What is the first and last name of the faculty participating in the most activities?
SQL: SELECT  T1.fname ,  T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID GROUP BY T1.FacID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: faculty_participates_in, faculty)
Question: Find the first and last name of the faculty who is involved in the largest number of activities.
SQL: SELECT  T1.fname ,  T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID GROUP BY T1.FacID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: faculty_participates_in, activity)
Question: What is the name of the activity that has the most faculty members involved in?
SQL: SELECT T1.activity_name FROM Activity AS T1 JOIN Faculty_participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: faculty_participates_in, activity)
Question: Which activity has the most faculty members participating in? Find the activity name.
SQL: SELECT T1.activity_name FROM Activity AS T1 JOIN Faculty_participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: student, participates_in)
Question: Show the ids of the students who don't participate in any activity.
SQL: SELECT StuID FROM Student EXCEPT SELECT StuID FROM Participates_in
Database: activity_1 (tables: student, participates_in)
Question: What are the ids of the students who are not involved in any activity
SQL: SELECT StuID FROM Student EXCEPT SELECT StuID FROM Participates_in
Database: activity_1 (tables: student, participates_in)
Question: Show the ids for all the students who participate in an activity and are under 20.
SQL: SELECT StuID FROM Participates_in INTERSECT SELECT StuID FROM Student WHERE age  <  20
Database: activity_1 (tables: student, participates_in)
Question: What are the ids of the students who are under 20 years old and are involved in at least one activity.
SQL: SELECT StuID FROM Participates_in INTERSECT SELECT StuID FROM Student WHERE age  <  20
Database: activity_1 (tables: student, participates_in)
Question: What is the first and last name of the student participating in the most activities?
SQL: SELECT T1.fname ,  T1.lname FROM Student AS T1 JOIN Participates_in AS T2 ON T1.StuID  =  T2.StuID GROUP BY T1.StuID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: student, participates_in)
Question: Tell me the first and last name of the student who has the most activities.
SQL: SELECT T1.fname ,  T1.lname FROM Student AS T1 JOIN Participates_in AS T2 ON T1.StuID  =  T2.StuID GROUP BY T1.StuID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: activity, participates_in)
Question: What is the name of the activity with the most students?
SQL: SELECT T1.activity_name FROM Activity AS T1 JOIN Participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: activity, participates_in)
Question: Find the name of the activity that has the largest number of student participants.
SQL: SELECT T1.activity_name FROM Activity AS T1 JOIN Participates_in AS T2 ON T1.actID  =  T2.actID GROUP BY T1.actID ORDER BY count(*) DESC LIMIT 1
Database: activity_1 (tables: faculty_participates_in, activity, faculty)
Question: Find the first names of the faculty members who are playing Canoeing or Kayaking.
SQL: SELECT DISTINCT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Canoeing' OR T3.activity_name  =  'Kayaking'
Database: activity_1 (tables: faculty_participates_in, activity, faculty)
Question: Which faculty members are playing either Canoeing or Kayaking? Tell me their first names.
SQL: SELECT DISTINCT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Canoeing' OR T3.activity_name  =  'Kayaking'
Database: activity_1 (tables: faculty_participates_in, activity, faculty, faculty)
Question: Find the first names of professors who are not playing Canoeing or Kayaking.
SQL: SELECT lname FROM faculty WHERE rank  =  'Professor' EXCEPT SELECT DISTINCT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Canoeing' OR T3.activity_name  =  'Kayaking'
Database: activity_1 (tables: faculty_participates_in, activity, faculty, faculty)
Question: What are the first names of the professors who do not play Canoeing or Kayaking as activities?
SQL: SELECT lname FROM faculty WHERE rank  =  'Professor' EXCEPT SELECT DISTINCT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Canoeing' OR T3.activity_name  =  'Kayaking'
Database: activity_1 (tables: faculty_participates_in, activity, faculty)
Question: Find the first names of the faculty members who participate in Canoeing and Kayaking.
SQL: SELECT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Canoeing' INTERSECT SELECT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Kayaking'
Database: activity_1 (tables: faculty_participates_in, activity, faculty)
Question: What are the first names of the faculty members playing both Canoeing and Kayaking?
SQL: SELECT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Canoeing' INTERSECT SELECT T1.lname FROM Faculty AS T1 JOIN Faculty_participates_in AS T2 ON T1.facID  =  T2.facID JOIN activity AS T3 ON T2.actid  =  T2.actid WHERE T3.activity_name  =  'Kayaking'
Database: activity_1 (tables: participates_in, activity)
Question: Find the ids of the students who participate in Canoeing and Kayaking.
SQL: SELECT T1.stuid FROM participates_in AS T1 JOIN activity AS T2 ON T2.actid  =  T2.actid WHERE T2.activity_name  =  'Canoeing' INTERSECT SELECT T1.stuid FROM participates_in AS T1 JOIN activity AS T2 ON T2.actid  =  T2.actid WHERE T2.activity_name  =  'Kayaking'
Database: activity_1 (tables: participates_in, activity)
Question: Which students participate in both Canoeing and Kayaking as their activities? Tell me their student ids.
SQL: SELECT T1.stuid FROM participates_in AS T1 JOIN activity AS T2 ON T2.actid  =  T2.actid WHERE T2.activity_name  =  'Canoeing' INTERSECT SELECT T1.stuid FROM participates_in AS T1 JOIN activity AS T2 ON T2.actid  =  T2.actid WHERE T2.activity_name  =  'Kayaking'
Database: flight_4 (tables: airports)
Question: Find the name of the airport in the city of Goroka.
SQL: SELECT name FROM airports WHERE city  =  'Goroka'
Database: flight_4 (tables: airports)
Question: What are the names of the airports in the city of Goroka?
SQL: SELECT name FROM airports WHERE city  =  'Goroka'
Database: flight_4 (tables: airports)
Question: Find the name, city, country, and altitude (or elevation) of the airports in the city of New York.
SQL: SELECT name ,  city ,  country ,  elevation FROM airports WHERE city  =  'New York'
Database: flight_4 (tables: airports)
Question: What is the name, city, country, and elevation for every airport in the city of New York?
SQL: SELECT name ,  city ,  country ,  elevation FROM airports WHERE city  =  'New York'
Database: flight_4 (tables: airlines)
Question: How many airlines are there?
SQL: SELECT count(*) FROM airlines
Database: flight_4 (tables: airlines)
Question: What is the total number of airlines?
SQL: SELECT count(*) FROM airlines
Database: flight_4 (tables: airlines)
Question: How many airlines does Russia has?
SQL: SELECT count(*) FROM airlines WHERE country  =  'Russia'
Database: flight_4 (tables: airlines)
Question: What is the number of airlines based in Russia?
SQL: SELECT count(*) FROM airlines WHERE country  =  'Russia'
Database: flight_4 (tables: airports)
Question: What is the maximum elevation of all airports in the country of Iceland?
SQL: SELECT max(elevation) FROM airports WHERE country  =  'Iceland'
Database: flight_4 (tables: airports)
Question: What is the highest elevation of an airport in the country of Iceland?
SQL: SELECT max(elevation) FROM airports WHERE country  =  'Iceland'
Database: flight_4 (tables: airports)
Question: Find the name of the airports located in Cuba or Argentina.
SQL: SELECT name FROM airports WHERE country  =  'Cuba' OR country  =  'Argentina'