target-benchmark/spider-queries huggingface dataset:
Database: cre_Doc_Tracking_DB (tables: roles, employees)
Question: Find the names of all the employees whose the role name is "Editor".
SQL: SELECT T1.employee_name FROM Employees AS T1 JOIN ROLES AS T2 ON T1.role_code  =  T2.role_code WHERE T2.role_name  =  "Editor"
Database: cre_Doc_Tracking_DB (tables: roles, employees)
Question: Show the employee ids for all employees with role name "Human Resource" or "Manager".
SQL: SELECT T1.employee_id FROM Employees AS T1 JOIN ROLES AS T2 ON T1.role_code  =  T2.role_code WHERE T2.role_name  =  "Human Resource" OR T2.role_name  =  "Manager"
Database: cre_Doc_Tracking_DB (tables: roles, employees)
Question: What are the employee ids of the employees whose role name is "Human Resource" or "Manager"?
SQL: SELECT T1.employee_id FROM Employees AS T1 JOIN ROLES AS T2 ON T1.role_code  =  T2.role_code WHERE T2.role_name  =  "Human Resource" OR T2.role_name  =  "Manager"
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: What are the different location codes for documents?
SQL: SELECT DISTINCT location_code FROM Document_locations
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: Give me all the distinct location codes for documents.
SQL: SELECT DISTINCT location_code FROM Document_locations
Database: cre_Doc_Tracking_DB (tables: ref_locations, all_documents, document_locations)
Question: Show the location name for document "Robin CV".
SQL: SELECT T3.location_name FROM All_documents AS T1 JOIN Document_locations AS T2 ON T1.document_id  =  T2.document_id JOIN Ref_locations AS T3 ON T2.location_code  =  T3.location_code WHERE T1.document_name  =  "Robin CV"
Database: cre_Doc_Tracking_DB (tables: ref_locations, all_documents, document_locations)
Question: What is the location name of the document "Robin CV"?
SQL: SELECT T3.location_name FROM All_documents AS T1 JOIN Document_locations AS T2 ON T1.document_id  =  T2.document_id JOIN Ref_locations AS T3 ON T2.location_code  =  T3.location_code WHERE T1.document_name  =  "Robin CV"
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: Show the location code, the starting date and ending data in that location for all the documents.
SQL: SELECT location_code ,  date_in_location_from ,  date_in_locaton_to FROM Document_locations
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: What are each document's location code, and starting date and ending data in that location?
SQL: SELECT location_code ,  date_in_location_from ,  date_in_locaton_to FROM Document_locations
Database: cre_Doc_Tracking_DB (tables: all_documents, document_locations)
Question: What is "the date in location from" and "the date in location to" for the document with name "Robin CV"?
SQL: SELECT T1.date_in_location_from ,  T1.date_in_locaton_to FROM Document_locations AS T1 JOIN All_documents AS T2 ON T1.document_id  =  T2.document_id WHERE T2.document_name  =  "Robin CV"
Database: cre_Doc_Tracking_DB (tables: all_documents, document_locations)
Question: Find the starting date and ending data in location for the document named "Robin CV".
SQL: SELECT T1.date_in_location_from ,  T1.date_in_locaton_to FROM Document_locations AS T1 JOIN All_documents AS T2 ON T1.document_id  =  T2.document_id WHERE T2.document_name  =  "Robin CV"
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: Show the location codes and the number of documents in each location.
SQL: SELECT location_code ,  count(*) FROM Document_locations GROUP BY location_code
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: What is the code of each location and the number of documents in that location?
SQL: SELECT location_code ,  count(*) FROM Document_locations GROUP BY location_code
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: What is the location code with the most documents?
SQL: SELECT location_code FROM Document_locations GROUP BY location_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: Find the code of the location with the largest number of documents.
SQL: SELECT location_code FROM Document_locations GROUP BY location_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: Show the location codes with at least 3 documents.
SQL: SELECT location_code FROM Document_locations GROUP BY location_code HAVING count(*)  >=  3
Database: cre_Doc_Tracking_DB (tables: document_locations)
Question: What are the codes of the locations with at least three documents?
SQL: SELECT location_code FROM Document_locations GROUP BY location_code HAVING count(*)  >=  3
Database: cre_Doc_Tracking_DB (tables: ref_locations, document_locations)
Question: Show the location name and code with the least documents.
SQL: SELECT T2.location_name ,  T1.location_code FROM Document_locations AS T1 JOIN Ref_locations AS T2 ON T1.location_code  =  T2.location_code GROUP BY T1.location_code ORDER BY count(*) ASC LIMIT 1
Database: cre_Doc_Tracking_DB (tables: ref_locations, document_locations)
Question: What are the name and code of the location with the smallest number of documents?
SQL: SELECT T2.location_name ,  T1.location_code FROM Document_locations AS T1 JOIN Ref_locations AS T2 ON T1.location_code  =  T2.location_code GROUP BY T1.location_code ORDER BY count(*) ASC LIMIT 1
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed, employees)
Question: What are the names of the employees who authorised the destruction and the employees who destroyed the corresponding documents?
SQL: SELECT T2.employee_name ,  T3.employee_name FROM Documents_to_be_destroyed AS T1 JOIN Employees AS T2 ON T1.Destruction_Authorised_by_Employee_ID = T2.employee_id JOIN Employees AS T3 ON T1.Destroyed_by_Employee_ID = T3.employee_id;
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed, employees)
Question: List the names of the employees who authorized the destruction of documents and the employees who destroyed the corresponding documents.
SQL: SELECT T2.employee_name ,  T3.employee_name FROM Documents_to_be_destroyed AS T1 JOIN Employees AS T2 ON T1.Destruction_Authorised_by_Employee_ID = T2.employee_id JOIN Employees AS T3 ON T1.Destroyed_by_Employee_ID = T3.employee_id;
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: Show the id of each employee and the number of document destruction authorised by that employee.
SQL: SELECT Destruction_Authorised_by_Employee_ID ,  count(*) FROM Documents_to_be_destroyed GROUP BY Destruction_Authorised_by_Employee_ID
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: What are the id of each employee and the number of document destruction authorised by that employee?
SQL: SELECT Destruction_Authorised_by_Employee_ID ,  count(*) FROM Documents_to_be_destroyed GROUP BY Destruction_Authorised_by_Employee_ID
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: Show the employee ids and the number of documents destroyed by each employee.
SQL: SELECT Destroyed_by_Employee_ID ,  count(*) FROM Documents_to_be_destroyed GROUP BY Destroyed_by_Employee_ID
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: What are the id of each employee and the number of document destroyed by that employee?
SQL: SELECT Destroyed_by_Employee_ID ,  count(*) FROM Documents_to_be_destroyed GROUP BY Destroyed_by_Employee_ID
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed, employees)
Question: Show the ids of the employees who don't authorize destruction for any document.
SQL: SELECT employee_id FROM Employees EXCEPT SELECT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed, employees)
Question: Which employees do not authorize destruction for any document? Give me their employee ids.
SQL: SELECT employee_id FROM Employees EXCEPT SELECT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: Show the ids of all employees who have authorized destruction.
SQL: SELECT DISTINCT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: What are the ids of all the employees who authorize document destruction?
SQL: SELECT DISTINCT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: Show the ids of all employees who have destroyed a document.
SQL: SELECT DISTINCT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: What are the ids of all the employees who have destroyed documents?
SQL: SELECT DISTINCT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed, employees)
Question: Show the ids of all employees who don't destroy any document.
SQL: SELECT employee_id FROM Employees EXCEPT SELECT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed, employees)
Question: Which employees do not destroy any document? Find their employee ids.
SQL: SELECT employee_id FROM Employees EXCEPT SELECT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: Show the ids of all employees who have either destroyed a document or made an authorization to do this.
SQL: SELECT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed UNION SELECT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed
Database: cre_Doc_Tracking_DB (tables: documents_to_be_destroyed)
Question: Which employees have either destroyed a document or made an authorization to do so? Return their employee ids.
SQL: SELECT Destroyed_by_Employee_ID FROM Documents_to_be_destroyed UNION SELECT Destruction_Authorised_by_Employee_ID FROM Documents_to_be_destroyed
Database: club_1 (tables: club)
Question: How many clubs are there?
SQL: SELECT count(*) FROM club
Database: club_1 (tables: club)
Question: Count the total number of clubs.
SQL: SELECT count(*) FROM club
Database: club_1 (tables: club)
Question: What are the names of all clubs?
SQL: SELECT clubname FROM club
Database: club_1 (tables: club)
Question: Give me the name of each club.
SQL: SELECT clubname FROM club
Database: club_1 (tables: student)
Question: How many students are there?
SQL: SELECT count(*) FROM student
Database: club_1 (tables: student)
Question: Count the total number of students.
SQL: SELECT count(*) FROM student
Database: club_1 (tables: student)
Question: What are the first names of all the students?
SQL: SELECT DISTINCT fname FROM student
Database: club_1 (tables: student)
Question: Find each student's first name.
SQL: SELECT DISTINCT fname FROM student
Database: club_1 (tables: student, club, member_of_club)
Question: Find the last names of the members of the club "Bootup Baltimore".
SQL: SELECT t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore"
Database: club_1 (tables: student, club, member_of_club)
Question: Who are the members of the club named "Bootup Baltimore"? Give me their last names.
SQL: SELECT t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore"
Database: club_1 (tables: student, club, member_of_club)
Question: Who are the members of the club named "Hopkins Student Enterprises"? Show the last name.
SQL: SELECT t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Hopkins Student Enterprises"
Database: club_1 (tables: student, club, member_of_club)
Question: Return the last name for the members of the club named "Hopkins Student Enterprises".
SQL: SELECT t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Hopkins Student Enterprises"
Database: club_1 (tables: student, club, member_of_club)
Question: How many members does the club "Tennis Club" has?
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Tennis Club"
Database: club_1 (tables: student, club, member_of_club)
Question: Count the members of the club "Tennis Club".
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Tennis Club"
Database: club_1 (tables: student, club, member_of_club)
Question: Find the number of members of club "Pen and Paper Gaming".
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Pen and Paper Gaming"
Database: club_1 (tables: student, club, member_of_club)
Question: How many people have membership in the club "Pen and Paper Gaming"?
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Pen and Paper Gaming"
Database: club_1 (tables: student, club, member_of_club)
Question: How many clubs does "Linda Smith" belong to?
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.fname  =  "Linda" AND t3.lname  =  "Smith"
Database: club_1 (tables: student, club, member_of_club)
Question: How many clubs does "Linda Smith" have membership for?
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.fname  =  "Linda" AND t3.lname  =  "Smith"
Database: club_1 (tables: student, club, member_of_club)
Question: Find the number of clubs where "Tracy Kim" is a member.
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.fname  =  "Tracy" AND t3.lname  =  "Kim"
Database: club_1 (tables: student, club, member_of_club)
Question: For how many clubs is "Tracy Kim" a member?
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.fname  =  "Tracy" AND t3.lname  =  "Kim"
Database: club_1 (tables: student, club, member_of_club)
Question: Find all the female members of club "Bootup Baltimore". Show the first name and last name.
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.sex  =  "F"
Database: club_1 (tables: student, club, member_of_club)
Question: Give me the first name and last name for all the female members of the club "Bootup Baltimore".
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.sex  =  "F"
Database: club_1 (tables: student, club, member_of_club)
Question: Find all the male members of club "Hopkins Student Enterprises". Show the first name and last name.
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Hopkins Student Enterprises" AND t3.sex  =  "M"
Database: club_1 (tables: student, club, member_of_club)
Question: What are the first name and last name of each male member in club "Hopkins Student Enterprises"?
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Hopkins Student Enterprises" AND t3.sex  =  "M"
Database: club_1 (tables: student, club, member_of_club)
Question: Find all members of "Bootup Baltimore" whose major is "600". Show the first name and last name.
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.major  =  "600"
Database: club_1 (tables: student, club, member_of_club)
Question: Which members of "Bootup Baltimore" major in "600"? Give me their first names and last names.
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.major  =  "600"
Database: club_1 (tables: student, club, member_of_club)
Question: Which club has the most members majoring in "600"?
SQL: SELECT t1.clubname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.major  =  "600" GROUP BY t1.clubname ORDER BY count(*) DESC LIMIT 1
Database: club_1 (tables: student, club, member_of_club)
Question: Find the club which has the largest number of members majoring in "600".
SQL: SELECT t1.clubname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.major  =  "600" GROUP BY t1.clubname ORDER BY count(*) DESC LIMIT 1
Database: club_1 (tables: student, club, member_of_club)
Question: Find the name of the club that has the most female students.
SQL: SELECT t1.clubname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.sex  =  "F" GROUP BY t1.clubname ORDER BY count(*) DESC LIMIT 1
Database: club_1 (tables: student, club, member_of_club)
Question: Which club has the most female students as their members? Give me the name of the club.
SQL: SELECT t1.clubname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.sex  =  "F" GROUP BY t1.clubname ORDER BY count(*) DESC LIMIT 1
Database: club_1 (tables: club)
Question: What is the description of the club named "Tennis Club"?
SQL: SELECT clubdesc FROM club WHERE clubname  =  "Tennis Club"
Database: club_1 (tables: club)
Question: Find the description of the club called "Tennis Club".
SQL: SELECT clubdesc FROM club WHERE clubname  =  "Tennis Club"
Database: club_1 (tables: club)
Question: Find the description of the club "Pen and Paper Gaming".
SQL: SELECT clubdesc FROM club WHERE clubname  =  "Pen and Paper Gaming"
Database: club_1 (tables: club)
Question: What is the description of the club "Pen and Paper Gaming"?
SQL: SELECT clubdesc FROM club WHERE clubname  =  "Pen and Paper Gaming"
Database: club_1 (tables: club)
Question: What is the location of the club named "Tennis Club"?
SQL: SELECT clublocation FROM club WHERE clubname  =  "Tennis Club"
Database: club_1 (tables: club)
Question: Where us the club named "Tennis Club" located?
SQL: SELECT clublocation FROM club WHERE clubname  =  "Tennis Club"
Database: club_1 (tables: club)
Question: Find the location of the club "Pen and Paper Gaming".
SQL: SELECT clublocation FROM club WHERE clubname  =  "Pen and Paper Gaming"
Database: club_1 (tables: club)
Question: Where is the club "Pen and Paper Gaming" located?
SQL: SELECT clublocation FROM club WHERE clubname  =  "Pen and Paper Gaming"
Database: club_1 (tables: club)
Question: Where is the club "Hopkins Student Enterprises" located?
SQL: SELECT clublocation FROM club WHERE clubname  =  "Hopkins Student Enterprises"
Database: club_1 (tables: club)
Question: Tell me the location of the club "Hopkins Student Enterprises".
SQL: SELECT clublocation FROM club WHERE clubname  =  "Hopkins Student Enterprises"
Database: club_1 (tables: club)
Question: Find the name of all the clubs at "AKW".
SQL: SELECT clubname FROM club WHERE clublocation  =  "AKW"
Database: club_1 (tables: club)
Question: Which clubs are located at "AKW"? Return the club names.
SQL: SELECT clubname FROM club WHERE clublocation  =  "AKW"
Database: club_1 (tables: club)
Question: How many clubs are located at "HHH"?
SQL: SELECT count(*) FROM club WHERE clublocation  =  "HHH"
Database: club_1 (tables: club)
Question: Count the number of clubs located at "HHH".
SQL: SELECT count(*) FROM club WHERE clublocation  =  "HHH"
Database: club_1 (tables: student, club, member_of_club)
Question: What are the first and last name of the president of the club "Bootup Baltimore"?
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t2.position  =  "President"
Database: club_1 (tables: student, club, member_of_club)
Question: Who is the president of the club "Bootup Baltimore"? Give me the first and last name.
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t2.position  =  "President"
Database: club_1 (tables: student, club, member_of_club)
Question: Who is the "CTO" of club "Hopkins Student Enterprises"? Show the first name and last name.
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Hopkins Student Enterprises" AND t2.position  =  "CTO"
Database: club_1 (tables: student, club, member_of_club)
Question: Find the first name and last name for the "CTO" of the club "Hopkins Student Enterprises"?
SQL: SELECT t3.fname ,  t3.lname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Hopkins Student Enterprises" AND t2.position  =  "CTO"
Database: club_1 (tables: club, member_of_club)
Question: How many different roles are there in the club "Bootup Baltimore"?
SQL: SELECT count(DISTINCT t2.position) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid WHERE t1.clubname  =  "Bootup Baltimore"
Database: club_1 (tables: club, member_of_club)
Question: Count the number of different positions in the club "Bootup Baltimore".
SQL: SELECT count(DISTINCT t2.position) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid WHERE t1.clubname  =  "Bootup Baltimore"
Database: club_1 (tables: student, club, member_of_club)
Question: How many members of "Bootup Baltimore" are older than 18?
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.age  >  18
Database: club_1 (tables: student, club, member_of_club)
Question: Count the number of members in club "Bootup Baltimore" whose age is above 18.
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.age  >  18
Database: club_1 (tables: student, club, member_of_club)
Question: How many members of club "Bootup Baltimore" are younger than 18?
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.age  <  18
Database: club_1 (tables: student, club, member_of_club)
Question: Count the number of members in club "Bootup Baltimore" whose age is below 18.
SQL: SELECT count(*) FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t1.clubname  =  "Bootup Baltimore" AND t3.age  <  18
Database: club_1 (tables: student, club, member_of_club)
Question: Find the names of all the clubs that have at least a member from the city with city code "BAL".
SQL: SELECT DISTINCT t1.clubname FROM club AS t1 JOIN member_of_club AS t2 ON t1.clubid  =  t2.clubid JOIN student AS t3 ON t2.stuid  =  t3.stuid WHERE t3.city_code  =  "BAL"