target-benchmark/spider-queries huggingface dataset:
Database: aan_1 (tables: author, author_list)
Question: Count the number of collaborators that Mckeown , Kathleen has had .
SQL: select count (distinct t2.author_id) from author_list as t1 join author_list as t2 on t1.paper_id  =  t2.paper_id and t1.author_id != t2.author_id join author as t3 on t1.author_id  =  t3.author_id where t3.name = "mckeown ,  kathleen"
Database: aan_1 (tables: author, author_list)
Question: Who has the most papers co-authored with Mckeown , Kathleen ?
SQL: select t4.name from author_list as t1 join author_list as t2 on t1.paper_id  =  t2.paper_id and t1.author_id != t2.author_id join author as t3 on t1.author_id  =  t3.author_id join author as t4 on t2.author_id  =  t4.author_id where t3.name = "mckeown ,  kathleen" group by t2.author_id order by count(*) desc limit 1
Database: aan_1 (tables: author, author_list)
Question: What is the name of the author who has co-authored the most papers with Mckeown , Kathleen ?
SQL: select t4.name from author_list as t1 join author_list as t2 on t1.paper_id  =  t2.paper_id and t1.author_id != t2.author_id join author as t3 on t1.author_id  =  t3.author_id join author as t4 on t2.author_id  =  t4.author_id where t3.name = "mckeown ,  kathleen" group by t2.author_id order by count(*) desc limit 1
Database: aan_1 (tables: paper)
Question: Find the id of the papers whose title has the key word 'translation'.
SQL: SELECT paper_id FROM Paper WHERE title LIKE "%translation%"
Database: aan_1 (tables: paper)
Question: What are the ids for papers with titles containing 'translation'?
SQL: SELECT paper_id FROM Paper WHERE title LIKE "%translation%"
Database: aan_1 (tables: paper, citation)
Question: Find the id and title of the papers that are never cited by others.
SQL: SELECT paper_id ,  title FROM Paper WHERE paper_id NOT IN (SELECT cited_paper_id FROM Citation)
Database: aan_1 (tables: paper, citation)
Question: What are the ids and titles for papers that have never been cited?
SQL: SELECT paper_id ,  title FROM Paper WHERE paper_id NOT IN (SELECT cited_paper_id FROM Citation)
Database: aan_1 (tables: author_list, affiliation)
Question: Find the name of the affiliation whose address contains 'China' and publishes the greatest number of papers.
SQL: SELECT T1.name FROM Affiliation AS T1 JOIN Author_list AS T2 ON T1.affiliation_id  =  T2.affiliation_id WHERE T1.address LIKE "%China%" GROUP BY T1.affiliation_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: author_list, affiliation)
Question: What is the name of the affiliation which publishes the greatest number of papers among those whose address contains 'China'.
SQL: SELECT T1.name FROM Affiliation AS T1 JOIN Author_list AS T2 ON T1.affiliation_id  =  T2.affiliation_id WHERE T1.address LIKE "%China%" GROUP BY T1.affiliation_id ORDER BY count(*) DESC LIMIT 1
Database: aan_1 (tables: paper)
Question: Find the number of papers published in different conferences each year.
SQL: SELECT count(*) ,  venue ,  YEAR FROM Paper GROUP BY venue ,  YEAR
Database: aan_1 (tables: paper)
Question: How many papers are published in each venue in each year?
SQL: SELECT count(*) ,  venue ,  YEAR FROM Paper GROUP BY venue ,  YEAR
Database: aan_1 (tables: author_list, affiliation)
Question: Find the total number of papers for each affiliation.
SQL: SELECT count(DISTINCT T2.paper_id) ,  T1.name FROM Affiliation AS T1 JOIN Author_list AS T2 ON T1.affiliation_id  =  T2.affiliation_id GROUP BY T1.affiliation_id
Database: aan_1 (tables: author_list, affiliation)
Question: How many papers has each affiliation published?
SQL: SELECT count(DISTINCT T2.paper_id) ,  T1.name FROM Affiliation AS T1 JOIN Author_list AS T2 ON T1.affiliation_id  =  T2.affiliation_id GROUP BY T1.affiliation_id
Database: aan_1 (tables: paper, citation)
Question: Find the titles of papers that have more than 50 citations.
SQL: SELECT T2.title FROM Citation AS T1 JOIN Paper AS T2 ON T1.cited_paper_id  =  T2.paper_id GROUP BY T1.cited_paper_id HAVING count(*)  >  50
Database: aan_1 (tables: paper, citation)
Question: What are the titles for papers with more than 50 citations?
SQL: SELECT T2.title FROM Citation AS T1 JOIN Paper AS T2 ON T1.cited_paper_id  =  T2.paper_id GROUP BY T1.cited_paper_id HAVING count(*)  >  50
Database: aan_1 (tables: author, author_list, citation)
Question: Find the number of authors who did not publish any paper that is cited more than 50 times.
SQL: SELECT count(*) FROM Author WHERE Author_id NOT IN ( SELECT T2.author_id FROM Citation AS T1 JOIN Author_list AS T2 ON T1.cited_paper_id  =  T2.paper_id GROUP BY T1.cited_paper_id HAVING count(DISTINCT T1.paper_id)  >  50)
Database: aan_1 (tables: author, author_list, citation)
Question: How many authors have not published a paper with more than 50 citations?
SQL: SELECT count(*) FROM Author WHERE Author_id NOT IN ( SELECT T2.author_id FROM Citation AS T1 JOIN Author_list AS T2 ON T1.cited_paper_id  =  T2.paper_id GROUP BY T1.cited_paper_id HAVING count(DISTINCT T1.paper_id)  >  50)
Database: aan_1 (tables: author, paper, author_list)
Question: Find the names of authors who published some paper on NAACL and ACL in the year 2009.
SQL: SELECT name FROM Author WHERE author_id IN (SELECT T1.author_id FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id WHERE T2.venue  =  "ACL" AND T2.year  =  2009 INTERSECT SELECT T1.author_id FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id WHERE T2.venue  =  "NAACL" AND T2.year  =  2009)
Database: aan_1 (tables: author, paper, author_list)
Question: What are the names of authors who published in both NAACL and ACL in 2009?
SQL: SELECT name FROM Author WHERE author_id IN (SELECT T1.author_id FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id WHERE T2.venue  =  "ACL" AND T2.year  =  2009 INTERSECT SELECT T1.author_id FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id WHERE T2.venue  =  "NAACL" AND T2.year  =  2009)
Database: aan_1 (tables: author, paper, author_list)
Question: Find the name of authors who have never published a paper in ACL.
SQL: SELECT name FROM Author WHERE author_id NOT IN (SELECT T1.author_id FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id WHERE T2.venue  =  "ACL")
Database: aan_1 (tables: author, paper, author_list)
Question: What are the names of authors who have not published a paper in ACL?
SQL: SELECT name FROM Author WHERE author_id NOT IN (SELECT T1.author_id FROM Author_list AS T1 JOIN Paper AS T2 ON T1.paper_id  =  T2.paper_id WHERE T2.venue  =  "ACL")
Database: conference (tables: conference)
Question: How many conferences are there?
SQL: SELECT count(*) FROM conference
Database: conference (tables: conference)
Question: What is the total number of conferences?
SQL: SELECT count(*) FROM conference
Database: conference (tables: conference)
Question: List all distinct conference names.
SQL: SELECT DISTINCT conference_name FROM conference
Database: conference (tables: conference)
Question: What are the different conference names?
SQL: SELECT DISTINCT conference_name FROM conference
Database: conference (tables: conference)
Question: List all conference name, year, and location.
SQL: SELECT conference_name ,  YEAR ,  LOCATION FROM conference
Database: conference (tables: conference)
Question: What are the names, years, and locations of all conferences?
SQL: SELECT conference_name ,  YEAR ,  LOCATION FROM conference
Database: conference (tables: conference)
Question: Show all conference names and the number of times each conference has.
SQL: SELECT conference_name ,  count(*) FROM conference GROUP BY conference_name
Database: conference (tables: conference)
Question: For each conference name, how many times has it occurred?
SQL: SELECT conference_name ,  count(*) FROM conference GROUP BY conference_name
Database: conference (tables: conference)
Question: show all years and the number of conferences in each year.
SQL: SELECT YEAR ,  count(*) FROM conference GROUP BY YEAR
Database: conference (tables: conference)
Question: How many conferences occur every year?
SQL: SELECT YEAR ,  count(*) FROM conference GROUP BY YEAR
Database: conference (tables: conference)
Question: which year has least number of conferences?
SQL: SELECT YEAR FROM conference GROUP BY YEAR ORDER BY count(*) LIMIT 1
Database: conference (tables: conference)
Question: What year had the fewest conferences?
SQL: SELECT YEAR FROM conference GROUP BY YEAR ORDER BY count(*) LIMIT 1
Database: conference (tables: conference)
Question: Show all locations where at least two conferences are located.
SQL: SELECT LOCATION FROM conference GROUP BY LOCATION HAVING count(*)  >=  2
Database: conference (tables: conference)
Question: What are all locations that have hosted at least two conferences?
SQL: SELECT LOCATION FROM conference GROUP BY LOCATION HAVING count(*)  >=  2
Database: conference (tables: institution)
Question: Show the institution name, location and founded year of all institutions.
SQL: SELECT institution_name ,  LOCATION ,  founded FROM institution
Database: conference (tables: institution)
Question: What are the names, locations, and founding years for all institutions?
SQL: SELECT institution_name ,  LOCATION ,  founded FROM institution
Database: conference (tables: institution)
Question: How many institution are founded between 1850 and 1900?
SQL: SELECT count(*) FROM institution WHERE founded BETWEEN 1850 AND 1900
Database: conference (tables: institution)
Question: How many institutions were founded between 1850 and 1900?
SQL: SELECT count(*) FROM institution WHERE founded BETWEEN 1850 AND 1900
Database: conference (tables: institution)
Question: Show the institution name and location of institution that is most recently founded.
SQL: SELECT institution_name ,  LOCATION FROM institution ORDER BY founded DESC LIMIT 1
Database: conference (tables: institution)
Question: What are the names and locations of the most recently-founded institution?
SQL: SELECT institution_name ,  LOCATION FROM institution ORDER BY founded DESC LIMIT 1
Database: conference (tables: institution, staff)
Question: Show the institution name and the number of staff for each institution founded after 1800.
SQL: SELECT T1.institution_name ,  count(*) FROM institution AS T1 JOIN staff AS T2 ON T1.institution_id  =  T2.institution_id WHERE T1.founded  >  1800 GROUP BY T2.institution_id
Database: conference (tables: institution, staff)
Question: For each institution id , how many staff members does each institution have that was founded after 1800 ? return their names .
SQL: select t1.institution_name ,  count(*) from institution as t1 join staff as t2 on t1.institution_id  =  t2.institution_id where t1.founded  >  1800 group by t2.institution_id
Database: conference (tables: institution, staff)
Question: Show institution name which there is no staff in our record.
SQL: SELECT institution_name FROM institution WHERE institution_id NOT IN (SELECT institution_id FROM staff)
Database: conference (tables: institution, staff)
Question: What is the name of the institution with no staff in the records?
SQL: SELECT institution_name FROM institution WHERE institution_id NOT IN (SELECT institution_id FROM staff)
Database: conference (tables: staff)
Question: Show all staff name who are above the average age.
SQL: SELECT name FROM staff WHERE age  >  (SELECT avg(age) FROM staff)
Database: conference (tables: staff)
Question: What are the names of all staff members who are older than average?
SQL: SELECT name FROM staff WHERE age  >  (SELECT avg(age) FROM staff)
Database: conference (tables: staff)
Question: What is the maximum and minimum age of all staff from the United States?
SQL: SELECT max(age) ,  min(age) FROM staff
Database: conference (tables: staff)
Question: What are the maximum and minimum ages for all staff?
SQL: SELECT max(age) ,  min(age) FROM staff
Database: conference (tables: conference, conference_participation, staff)
Question: Show all conference names which the staff from Canada attends.
SQL: SELECT T1.conference_name FROM conference AS T1 JOIN conference_participation AS T2 ON T1.conference_id = T2.conference_id JOIN staff AS T3 ON T2.staff_id  =  T3.staff_id WHERE T3.nationality  =  "Canada"
Database: conference (tables: conference, conference_participation, staff)
Question: What are the names of all the conferences that has staff from Canada attending?
SQL: SELECT T1.conference_name FROM conference AS T1 JOIN conference_participation AS T2 ON T1.conference_id = T2.conference_id JOIN staff AS T3 ON T2.staff_id  =  T3.staff_id WHERE T3.nationality  =  "Canada"
Database: conference (tables: conference_participation, staff)
Question: Show all staff names who have been both speaker and sponsor in some conference.
SQL: SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 ON T1.staff_id  =  T2.staff_id WHERE T2.role  =  'Speaker' INTERSECT SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 ON T1.staff_id  =  T2.staff_id WHERE T2.role  =  'Sponsor'
Database: conference (tables: conference_participation, staff)
Question: What are the names of the staff members who have been both a speaker and a sponsor at some conference?
SQL: SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 ON T1.staff_id  =  T2.staff_id WHERE T2.role  =  'Speaker' INTERSECT SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 ON T1.staff_id  =  T2.staff_id WHERE T2.role  =  'Sponsor'
Database: conference (tables: conference, conference, conference_participation, staff)
Question: Show all names who have been in both ACL and Naccl.
SQL: SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 JOIN Conference AS T3 ON T1.staff_id  =  T2.staff_id AND T2.conference_id  =  T3.conference_id WHERE T3.Conference_name  =  'ACL' INTERSECT SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 JOIN conference AS T3 ON T1.staff_id  =  T2.staff_id AND T2.conference_id  =  T3.conference_id WHERE T3.Conference_name  =  'Naccl'
Database: conference (tables: conference, conference, conference_participation, staff)
Question: What are the names of everbody who has participated in both the ACL and NACCL conferences?
SQL: SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 JOIN Conference AS T3 ON T1.staff_id  =  T2.staff_id AND T2.conference_id  =  T3.conference_id WHERE T3.Conference_name  =  'ACL' INTERSECT SELECT T1.name FROM staff AS T1 JOIN conference_participation AS T2 JOIN conference AS T3 ON T1.staff_id  =  T2.staff_id AND T2.conference_id  =  T3.conference_id WHERE T3.Conference_name  =  'Naccl'
Database: conference (tables: conference, conference_participation, staff)
Question: Show all staff names who attend a conference in 2003 or 2004.
SQL: SELECT DISTINCT T1.name FROM staff AS T1 JOIN conference_participation AS T2 JOIN Conference AS T3 ON T1.staff_id  =  T2.staff_id AND T2.conference_id  =  T3.conference_id WHERE T3.year  =  2003 OR T3.year  =  2004
Database: conference (tables: conference, conference_participation, staff)
Question: What are the staff names who participated in conferences between 2003 or 2004?
SQL: SELECT DISTINCT T1.name FROM staff AS T1 JOIN conference_participation AS T2 JOIN Conference AS T3 ON T1.staff_id  =  T2.staff_id AND T2.conference_id  =  T3.conference_id WHERE T3.year  =  2003 OR T3.year  =  2004
Database: conference (tables: conference_participation, conference)
Question: Show the conference name and year and the number of participants for each conference.
SQL: SELECT T1.conference_name ,  T1.year ,  count(*) FROM Conference AS T1 JOIN Conference_participation AS T2 ON T1.conference_id  =  T2.conference_id GROUP BY T2.conference_id
Database: conference (tables: conference_participation, conference)
Question: For each conference id, what are their names, year, and number of participants?
SQL: SELECT T1.conference_name ,  T1.year ,  count(*) FROM Conference AS T1 JOIN Conference_participation AS T2 ON T1.conference_id  =  T2.conference_id GROUP BY T2.conference_id
Database: conference (tables: conference_participation, conference)
Question: Find the name of the conferences that have the top 2 most number of attendants.
SQL: SELECT T1.conference_name FROM Conference AS T1 JOIN Conference_participation AS T2 ON T1.conference_id  =  T2.conference_id GROUP BY T2.conference_id ORDER BY count(*) DESC LIMIT 2
Database: conference (tables: conference_participation, conference)
Question: What are the names of the conferences that have the top 2 most people attending?
SQL: SELECT T1.conference_name FROM Conference AS T1 JOIN Conference_participation AS T2 ON T1.conference_id  =  T2.conference_id GROUP BY T2.conference_id ORDER BY count(*) DESC LIMIT 2
Database: conference (tables: conference_participation, conference, staff)
Question: Find the name and nationality of the people who did not participate in any ACL conference.
SQL: SELECT name ,  nationality FROM staff WHERE staff_id NOT IN (SELECT T2.staff_id FROM Conference AS T1 JOIN Conference_participation AS T2 ON T1.conference_id  =  T2.conference_id WHERE T1.Conference_Name  =  "ACL")
Database: conference (tables: conference_participation, conference, staff)
Question: What are the names and nationalities of the people who did not participate in any ACL conferences?
SQL: SELECT name ,  nationality FROM staff WHERE staff_id NOT IN (SELECT T2.staff_id FROM Conference AS T1 JOIN Conference_participation AS T2 ON T1.conference_id  =  T2.conference_id WHERE T1.Conference_Name  =  "ACL")
Database: conference (tables: conference_participation, conference, institution, staff)
Question: Find the name and location of the universities that did not have any staff participated in any conference in 2004.
SQL: SELECT T1.Institution_Name ,  T1.location FROM institution AS T1 JOIN staff AS T2 ON T1.institution_id  =  T2.institution_id WHERE T2.staff_id NOT IN (SELECT T4.staff_id FROM Conference AS T3 JOIN Conference_participation AS T4 ON T3.conference_id  =  T4.conference_id WHERE T3.year  =  2004)
Database: conference (tables: conference_participation, conference, institution, staff)
Question: What are the names and locations of the universities that did not have any staff participating in any conferences in 2004?
SQL: SELECT T1.Institution_Name ,  T1.location FROM institution AS T1 JOIN staff AS T2 ON T1.institution_id  =  T2.institution_id WHERE T2.staff_id NOT IN (SELECT T4.staff_id FROM Conference AS T3 JOIN Conference_participation AS T4 ON T3.conference_id  =  T4.conference_id WHERE T3.year  =  2004)
Database: pilot_1 (tables: pilotskills)
Question: What is the name of the oldest pilot?
SQL: SELECT pilot_name FROM PilotSkills ORDER BY age DESC LIMIT 1
Database: pilot_1 (tables: pilotskills)
Question: Return the name of the oldest pilot.
SQL: SELECT pilot_name FROM PilotSkills ORDER BY age DESC LIMIT 1
Database: pilot_1 (tables: pilotskills)
Question: What are the names of pilots whose age is below the average age, ordered by age?
SQL: SELECT pilot_name FROM PilotSkills WHERE age  <  (SELECT avg(age) FROM PilotSkills) ORDER BY age
Database: pilot_1 (tables: pilotskills)
Question: Return the names of pilots who are younger than average, ordered by age ascending.
SQL: SELECT pilot_name FROM PilotSkills WHERE age  <  (SELECT avg(age) FROM PilotSkills) ORDER BY age
Database: pilot_1 (tables: pilotskills)
Question: Find all information of on pilots whose age is less than 30.
SQL: SELECT * FROM PilotSkills WHERE age  <  30
Database: pilot_1 (tables: pilotskills)
Question: What is all the information about pilots who are younger than 30 ?
SQL: select * from pilotskills where age  <  30
Database: pilot_1 (tables: pilotskills)
Question: Find the names of all pilots who have a plane named Piper Cub and is under 35.
SQL: SELECT pilot_name FROM PilotSkills WHERE age  <  35 AND plane_name  =  'Piper Cub'
Database: pilot_1 (tables: pilotskills)
Question: What are the names of pilots who are younger than 35 and have a plane named Piper Cub?
SQL: SELECT pilot_name FROM PilotSkills WHERE age  <  35 AND plane_name  =  'Piper Cub'
Database: pilot_1 (tables: hangar)
Question: Where is the plane F-14 Fighter located?
SQL: SELECT LOCATION FROM hangar WHERE plane_name  =  'F-14 Fighter'
Database: pilot_1 (tables: hangar)
Question: Return the location of the hangar in which F-14 Fighter is located.
SQL: SELECT LOCATION FROM hangar WHERE plane_name  =  'F-14 Fighter'
Database: pilot_1 (tables: hangar)
Question: How many different places have some plane?
SQL: SELECT count(DISTINCT LOCATION) FROM hangar
Database: pilot_1 (tables: hangar)
Question: Count the number of different locations of hangars.
SQL: SELECT count(DISTINCT LOCATION) FROM hangar
Database: pilot_1 (tables: pilotskills)
Question: Which plane does the pilot Jones with age 32 has?
SQL: SELECT plane_name FROM pilotskills WHERE pilot_name  =  'Jones'  AND age  =  32
Database: pilot_1 (tables: pilotskills)
Question: What are the names of planes that the pilot Jones who is 32 has?
SQL: SELECT plane_name FROM pilotskills WHERE pilot_name  =  'Jones'  AND age  =  32
Database: pilot_1 (tables: pilotskills)
Question: How many pilots who are older than 40?
SQL: SELECT count(*) FROM pilotskills WHERE age  >  40
Database: pilot_1 (tables: pilotskills)
Question: Count the number of pilots with age greater than 40.
SQL: SELECT count(*) FROM pilotskills WHERE age  >  40
Database: pilot_1 (tables: pilotskills)
Question: How many plane B-52 Bomber owned by the pilot who is under 35?
SQL: SELECT count(*) FROM pilotskills WHERE age  <  35 AND plane_name  =  'B-52 Bomber'
Database: pilot_1 (tables: pilotskills)
Question: Count the number of B-52 Bombers owned by pilots under 35.
SQL: SELECT count(*) FROM pilotskills WHERE age  <  35 AND plane_name  =  'B-52 Bomber'
Database: pilot_1 (tables: pilotskills)
Question: Who is the youngest pilot to fly the plane Piper Cub?
SQL: SELECT pilot_name FROM pilotskills WHERE plane_name  =  'Piper Cub' ORDER BY age LIMIT 1
Database: pilot_1 (tables: pilotskills)
Question: Return the name of the youngest pilot to fly Piper Cub.
SQL: SELECT pilot_name FROM pilotskills WHERE plane_name  =  'Piper Cub' ORDER BY age LIMIT 1
Database: pilot_1 (tables: pilotskills)
Question: What is the name of the most popular plane?
SQL: SELECT plane_name FROM pilotskills GROUP BY plane_name ORDER BY count(*) DESC LIMIT 1
Database: pilot_1 (tables: pilotskills)
Question: What is the name of the plane that is flown the most often?
SQL: SELECT plane_name FROM pilotskills GROUP BY plane_name ORDER BY count(*) DESC LIMIT 1
Database: pilot_1 (tables: pilotskills)
Question: What is the name of the least popular plane?
SQL: SELECT plane_name FROM pilotskills GROUP BY plane_name ORDER BY count(*) LIMIT 1
Database: pilot_1 (tables: pilotskills)
Question: What is the name of the plane that is flown the least often?
SQL: SELECT plane_name FROM pilotskills GROUP BY plane_name ORDER BY count(*) LIMIT 1
Database: pilot_1 (tables: pilotskills, hangar)
Question: How many pilots whose planes are in Chicago?
SQL: SELECT 	count(DISTINCT T1.pilot_name) FROM pilotskills AS T1 JOIN hangar AS T2 ON T1.plane_name  =  T2.plane_name WHERE T2.location  =  'Chicago'
Database: pilot_1 (tables: pilotskills, hangar)
Question: Count the number of pilots who have planes in Chicago.
SQL: SELECT 	count(DISTINCT T1.pilot_name) FROM pilotskills AS T1 JOIN hangar AS T2 ON T1.plane_name  =  T2.plane_name WHERE T2.location  =  'Chicago'
Database: pilot_1 (tables: pilotskills)
Question: What are the planes owned by pilot Smith with age 41?
SQL: SELECT plane_name FROM pilotskills WHERE pilot_name  =  'Smith' AND age  =  41
Database: pilot_1 (tables: pilotskills)
Question: Return the names of planes owned by the pilot whose name is Smith and is 41 years old.
SQL: SELECT plane_name FROM pilotskills WHERE pilot_name  =  'Smith' AND age  =  41
Database: pilot_1 (tables: pilotskills)
Question: How many distinct planes are owned across all pilots?
SQL: SELECT count(DISTINCT plane_name) FROM pilotskills
Database: pilot_1 (tables: pilotskills)
Question: Count the number of different plane names across all pilots.
SQL: SELECT count(DISTINCT plane_name) FROM pilotskills
Database: pilot_1 (tables: pilotskills)
Question: How many planes are owned by the pilot whose name is Smith?
SQL: SELECT count(plane_name) FROM pilotskills WHERE pilot_name  =  'Smith'