target-benchmark/spider-queries huggingface dataset:
Database: flight_2 (tables: flights, airports)
Question: How many flights depart from City Aberdeen?
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport  =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: Return the number of flights departing from Aberdeen.
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport  =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: How many flights arriving in Aberdeen city?
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport  =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: Return the number of flights arriving in Aberdeen.
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport  =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: How many flights depart from City 'Aberdeen' and have destination City 'Ashley'?
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport  =  T2.AirportCode JOIN AIRPORTS AS T3 ON T1.SourceAirport  =  T3.AirportCode WHERE T2.City  =  "Ashley" AND T3.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: How many flights fly from Aberdeen to Ashley?
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport  =  T2.AirportCode JOIN AIRPORTS AS T3 ON T1.SourceAirport  =  T3.AirportCode WHERE T2.City  =  "Ashley" AND T3.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airlines)
Question: How many flights does airline 'JetBlue Airways' have?
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T1.Airline  =  T2.uid WHERE T2.Airline = "JetBlue Airways"
Database: flight_2 (tables: flights, airlines)
Question: Give the number of Jetblue Airways flights.
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T1.Airline  =  T2.uid WHERE T2.Airline = "JetBlue Airways"
Database: flight_2 (tables: flights, airlines)
Question: How many 'United Airlines' flights go to Airport 'ASY'?
SQL: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline  =  T1.uid WHERE T1.Airline  =  "United Airlines" AND T2.DestAirport  =  "ASY"
Database: flight_2 (tables: flights, airlines)
Question: Count the number of United Airlines flights arriving in ASY Airport.
SQL: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline  =  T1.uid WHERE T1.Airline  =  "United Airlines" AND T2.DestAirport  =  "ASY"
Database: flight_2 (tables: flights, airlines)
Question: How many 'United Airlines' flights depart from Airport 'AHD'?
SQL: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline  =  T1.uid WHERE T1.Airline  =  "United Airlines" AND T2.SourceAirport  =  "AHD"
Database: flight_2 (tables: flights, airlines)
Question: Return the number of United Airlines flights leaving from AHD Airport.
SQL: SELECT count(*) FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T2.Airline  =  T1.uid WHERE T1.Airline  =  "United Airlines" AND T2.SourceAirport  =  "AHD"
Database: flight_2 (tables: flights, airports, airlines)
Question: How many United Airlines flights go to City 'Aberdeen'?
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport  =  T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid  =  T1.Airline WHERE T2.City  =  "Aberdeen" AND T3.Airline  =  "United Airlines"
Database: flight_2 (tables: flights, airports, airlines)
Question: Count the number of United Airlines flights that arrive in Aberdeen.
SQL: SELECT count(*) FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport  =  T2.AirportCode JOIN AIRLINES AS T3 ON T3.uid  =  T1.Airline WHERE T2.City  =  "Aberdeen" AND T3.Airline  =  "United Airlines"
Database: flight_2 (tables: flights, airports)
Question: Which city has most number of arriving flights?
SQL: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.DestAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airports)
Question: Which city has the most frequent destination airport?
SQL: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.DestAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airports)
Question: Which city has most number of departing flights?
SQL: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.SourceAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airports)
Question: Which city is the most frequent source airport?
SQL: SELECT T1.City FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.SourceAirport GROUP BY T1.City ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airports)
Question: What is the code of airport that has the highest number of flights?
SQL: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.DestAirport OR T1.AirportCode  =  T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airports)
Question: What is the airport code of the airport with the most flights?
SQL: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.DestAirport OR T1.AirportCode  =  T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airports)
Question: What is the code of airport that has fewest number of flights?
SQL: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.DestAirport OR T1.AirportCode  =  T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) LIMIT 1
Database: flight_2 (tables: flights, airports)
Question: Give the code of the airport with the least flights.
SQL: SELECT T1.AirportCode FROM AIRPORTS AS T1 JOIN FLIGHTS AS T2 ON T1.AirportCode  =  T2.DestAirport OR T1.AirportCode  =  T2.SourceAirport GROUP BY T1.AirportCode ORDER BY count(*) LIMIT 1
Database: flight_2 (tables: flights, airlines)
Question: Which airline has most number of flights?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airlines)
Question: What airline serves the most flights?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline ORDER BY count(*) DESC LIMIT 1
Database: flight_2 (tables: flights, airlines)
Question: Find the abbreviation and country of the airline that has fewest number of flights?
SQL: SELECT T1.Abbreviation ,  T1.Country FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline ORDER BY count(*) LIMIT 1
Database: flight_2 (tables: flights, airlines)
Question: What is the abbreviation of the airilne has the fewest flights and what country is it in?
SQL: SELECT T1.Abbreviation ,  T1.Country FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline ORDER BY count(*) LIMIT 1
Database: flight_2 (tables: flights, airlines)
Question: What are airlines that have some flight departing from airport 'AHD'?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "AHD"
Database: flight_2 (tables: flights, airlines)
Question: Which airlines have a flight with source airport AHD?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "AHD"
Database: flight_2 (tables: flights, airlines)
Question: What are airlines that have flights arriving at airport 'AHD'?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.DestAirport  =  "AHD"
Database: flight_2 (tables: flights, airlines)
Question: Which airlines have a flight with destination airport AHD?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.DestAirport  =  "AHD"
Database: flight_2 (tables: flights, airlines)
Question: Find all airlines that have flights from both airports 'APG' and 'CVO'.
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "APG" INTERSECT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "CVO"
Database: flight_2 (tables: flights, airlines)
Question: Which airlines have departing flights from both APG and CVO airports?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "APG" INTERSECT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "CVO"
Database: flight_2 (tables: flights, airlines)
Question: Find all airlines that have flights from airport 'CVO' but not from 'APG'.
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "CVO" EXCEPT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "APG"
Database: flight_2 (tables: flights, airlines)
Question: Which airlines have departures from CVO but not from APG airports?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "CVO" EXCEPT SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline WHERE T2.SourceAirport  =  "APG"
Database: flight_2 (tables: flights, airlines)
Question: Find all airlines that have at least 10 flights.
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline HAVING count(*)  >  10
Database: flight_2 (tables: flights, airlines)
Question: Which airlines have at least 10 flights?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline HAVING count(*)  >  10
Database: flight_2 (tables: flights, airlines)
Question: Find all airlines that have fewer than 200 flights.
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline HAVING count(*)  <  200
Database: flight_2 (tables: flights, airlines)
Question: Which airlines have less than 200 flights?
SQL: SELECT T1.Airline FROM AIRLINES AS T1 JOIN FLIGHTS AS T2 ON T1.uid  =  T2.Airline GROUP BY T1.Airline HAVING count(*)  <  200
Database: flight_2 (tables: flights, airlines)
Question: What are flight numbers of Airline "United Airlines"?
SQL: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T2.uid  =  T1.Airline WHERE T2.Airline  =  "United Airlines"
Database: flight_2 (tables: flights, airlines)
Question: Which flight numbers correspond to United Airlines flights?
SQL: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRLINES AS T2 ON T2.uid  =  T1.Airline WHERE T2.Airline  =  "United Airlines"
Database: flight_2 (tables: flights)
Question: What are flight numbers of flights departing from Airport "APG"?
SQL: SELECT FlightNo FROM FLIGHTS WHERE SourceAirport  =  "APG"
Database: flight_2 (tables: flights)
Question: Give the flight numbers of flights leaving from APG.
SQL: SELECT FlightNo FROM FLIGHTS WHERE SourceAirport  =  "APG"
Database: flight_2 (tables: flights)
Question: What are flight numbers of flights arriving at Airport "APG"?
SQL: SELECT FlightNo FROM FLIGHTS WHERE DestAirport  =  "APG"
Database: flight_2 (tables: flights)
Question: Give the flight numbers of flights landing at APG.
SQL: SELECT FlightNo FROM FLIGHTS WHERE DestAirport  =  "APG"
Database: flight_2 (tables: flights, airports)
Question: What are flight numbers of flights departing from City "Aberdeen "?
SQL: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport   =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: Give the flight numbers of flights leaving from Aberdeen.
SQL: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.SourceAirport   =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: What are flight numbers of flights arriving at City "Aberdeen"?
SQL: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport   =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: flights, airports)
Question: Give the flight numbers of flights arriving in Aberdeen.
SQL: SELECT T1.FlightNo FROM FLIGHTS AS T1 JOIN AIRPORTS AS T2 ON T1.DestAirport   =  T2.AirportCode WHERE T2.City  =  "Aberdeen"
Database: flight_2 (tables: airports, flights)
Question: Find the number of flights landing in the city of Aberdeen or Abilene.
SQL: SELECT count(*) FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport  =  T2.AirportCode WHERE T2.city  =  "Aberdeen" OR T2.city  =  "Abilene"
Database: flight_2 (tables: airports, flights)
Question: How many flights land in Aberdeen or Abilene?
SQL: SELECT count(*) FROM Flights AS T1 JOIN Airports AS T2 ON T1.DestAirport  =  T2.AirportCode WHERE T2.city  =  "Aberdeen" OR T2.city  =  "Abilene"
Database: flight_2 (tables: airports, flights)
Question: Find the name of airports which do not have any flight in and out.
SQL: SELECT AirportName FROM Airports WHERE AirportCode NOT IN (SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights)
Database: flight_2 (tables: airports, flights)
Question: Which airports do not have departing or arriving flights?
SQL: SELECT AirportName FROM Airports WHERE AirportCode NOT IN (SELECT SourceAirport FROM Flights UNION SELECT DestAirport FROM Flights)
Database: employee_hire_evaluation (tables: employee)
Question: How many employees are there?
SQL: SELECT count(*) FROM employee
Database: employee_hire_evaluation (tables: employee)
Question: Count the number of employees
SQL: SELECT count(*) FROM employee
Database: employee_hire_evaluation (tables: employee)
Question: Sort employee names by their age in ascending order.
SQL: SELECT name FROM employee ORDER BY age
Database: employee_hire_evaluation (tables: employee)
Question: List the names of employees and sort in ascending order of age.
SQL: SELECT name FROM employee ORDER BY age
Database: employee_hire_evaluation (tables: employee)
Question: What is the number of employees from each city?
SQL: SELECT count(*) ,  city FROM employee GROUP BY city
Database: employee_hire_evaluation (tables: employee)
Question: Count the number of employees for each city.
SQL: SELECT count(*) ,  city FROM employee GROUP BY city
Database: employee_hire_evaluation (tables: employee)
Question: Which cities do more than one employee under age 30 come from?
SQL: SELECT city FROM employee WHERE age  <  30 GROUP BY city HAVING count(*)  >  1
Database: employee_hire_evaluation (tables: employee)
Question: Find the cities that have more than one employee under age 30.
SQL: SELECT city FROM employee WHERE age  <  30 GROUP BY city HAVING count(*)  >  1
Database: employee_hire_evaluation (tables: shop)
Question: Find the number of shops in each location.
SQL: SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION
Database: employee_hire_evaluation (tables: shop)
Question: How many shops are there in each location?
SQL: SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION
Database: employee_hire_evaluation (tables: shop)
Question: Find the manager name and district of the shop whose number of products is the largest.
SQL: SELECT manager_name ,  district FROM shop ORDER BY number_products DESC LIMIT 1
Database: employee_hire_evaluation (tables: shop)
Question: What are the manager name and district of the shop that sells the largest number of products?
SQL: SELECT manager_name ,  district FROM shop ORDER BY number_products DESC LIMIT 1
Database: employee_hire_evaluation (tables: shop)
Question: find the minimum and maximum number of products of all stores.
SQL: SELECT min(Number_products) ,  max(Number_products) FROM shop
Database: employee_hire_evaluation (tables: shop)
Question: What are the minimum and maximum number of products across all the shops?
SQL: SELECT min(Number_products) ,  max(Number_products) FROM shop
Database: employee_hire_evaluation (tables: shop)
Question: Return the name, location and district of all shops in descending order of number of products.
SQL: SELECT name ,  LOCATION ,  district FROM shop ORDER BY number_products DESC
Database: employee_hire_evaluation (tables: shop)
Question: Sort all the shops by number products in descending order, and return the name, location and district of each shop.
SQL: SELECT name ,  LOCATION ,  district FROM shop ORDER BY number_products DESC
Database: employee_hire_evaluation (tables: shop)
Question: Find the names of stores whose number products is more than the average number of products.
SQL: SELECT name FROM shop WHERE number_products  >  (SELECT avg(number_products) FROM shop)
Database: employee_hire_evaluation (tables: shop)
Question: Which shops' number products is above the average? Give me the shop names.
SQL: SELECT name FROM shop WHERE number_products  >  (SELECT avg(number_products) FROM shop)
Database: employee_hire_evaluation (tables: employee, evaluation)
Question: find the name of employee who was awarded the most times in the evaluation.
SQL: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID  =  t2.Employee_ID GROUP BY t2.Employee_ID ORDER BY count(*) DESC LIMIT 1
Database: employee_hire_evaluation (tables: employee, evaluation)
Question: Which employee received the most awards in evaluations? Give me the employee name.
SQL: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID  =  t2.Employee_ID GROUP BY t2.Employee_ID ORDER BY count(*) DESC LIMIT 1
Database: employee_hire_evaluation (tables: employee, evaluation)
Question: Find the name of the employee who got the highest one time bonus.
SQL: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID  =  t2.Employee_ID ORDER BY t2.bonus DESC LIMIT 1
Database: employee_hire_evaluation (tables: employee, evaluation)
Question: Which employee received the biggest bonus? Give me the employee name.
SQL: SELECT t1.name FROM employee AS t1 JOIN evaluation AS t2 ON t1.Employee_ID  =  t2.Employee_ID ORDER BY t2.bonus DESC LIMIT 1
Database: employee_hire_evaluation (tables: employee, evaluation)
Question: Find the names of employees who never won any award in the evaluation.
SQL: SELECT name FROM employee WHERE Employee_ID NOT IN (SELECT Employee_ID FROM evaluation)
Database: employee_hire_evaluation (tables: employee, evaluation)
Question: What are the names of the employees who never received any evaluation?
SQL: SELECT name FROM employee WHERE Employee_ID NOT IN (SELECT Employee_ID FROM evaluation)
Database: employee_hire_evaluation (tables: shop, hiring)
Question: What is the name of the shop that is hiring the largest number of employees?
SQL: SELECT t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t1.shop_id ORDER BY count(*) DESC LIMIT 1
Database: employee_hire_evaluation (tables: shop, hiring)
Question: Which shop has the most employees? Give me the shop name.
SQL: SELECT t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t1.shop_id ORDER BY count(*) DESC LIMIT 1
Database: employee_hire_evaluation (tables: shop, hiring)
Question: Find the name of the shops that do not hire any employee.
SQL: SELECT name FROM shop WHERE shop_id NOT IN (SELECT shop_id FROM hiring)
Database: employee_hire_evaluation (tables: shop, hiring)
Question: Which shops run with no employees? Find the shop names
SQL: SELECT name FROM shop WHERE shop_id NOT IN (SELECT shop_id FROM hiring)
Database: employee_hire_evaluation (tables: shop, hiring)
Question: Find the number of employees hired in each shop; show the shop name as well.
SQL: SELECT count(*) ,  t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t2.name
Database: employee_hire_evaluation (tables: shop, hiring)
Question: For each shop, return the number of employees working there and the name of the shop.
SQL: SELECT count(*) ,  t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t2.name
Database: employee_hire_evaluation (tables: evaluation)
Question: What is total bonus given in all evaluations?
SQL: SELECT sum(bonus) FROM evaluation
Database: employee_hire_evaluation (tables: evaluation)
Question: Find the total amount of bonus given in all the evaluations.
SQL: SELECT sum(bonus) FROM evaluation
Database: employee_hire_evaluation (tables: hiring)
Question: Give me all the information about hiring.
SQL: SELECT * FROM hiring
Database: employee_hire_evaluation (tables: hiring)
Question: What is all the information about hiring?
SQL: SELECT * FROM hiring
Database: employee_hire_evaluation (tables: shop)
Question: Which district has both stores with less than 3000 products and stores with more than 10000 products?
SQL: SELECT district FROM shop WHERE Number_products  <  3000 INTERSECT SELECT district FROM shop WHERE Number_products  >  10000
Database: employee_hire_evaluation (tables: shop)
Question: Find the districts in which there are both shops selling less than 3000 products and shops selling more than 10000 products.
SQL: SELECT district FROM shop WHERE Number_products  <  3000 INTERSECT SELECT district FROM shop WHERE Number_products  >  10000
Database: employee_hire_evaluation (tables: shop)
Question: How many different store locations are there?
SQL: SELECT count(DISTINCT LOCATION) FROM shop
Database: employee_hire_evaluation (tables: shop)
Question: Count the number of distinct store locations.
SQL: SELECT count(DISTINCT LOCATION) FROM shop
Database: cre_Doc_Template_Mgt (tables: documents)
Question: How many documents do we have?
SQL: SELECT count(*) FROM Documents
Database: cre_Doc_Template_Mgt (tables: documents)
Question: Count the number of documents.
SQL: SELECT count(*) FROM Documents
Database: cre_Doc_Template_Mgt (tables: documents)
Question: List document IDs, document names, and document descriptions for all documents.
SQL: SELECT document_id ,  document_name ,  document_description FROM Documents
Database: cre_Doc_Template_Mgt (tables: documents)
Question: What are the ids, names, and descriptions for all documents?
SQL: SELECT document_id ,  document_name ,  document_description FROM Documents
Database: cre_Doc_Template_Mgt (tables: documents)
Question: What is the document name and template id for document with description with the letter 'w' in it?
SQL: SELECT document_name ,  template_id FROM Documents WHERE Document_Description LIKE "%w%"
Database: cre_Doc_Template_Mgt (tables: documents)
Question: Return the names and template ids for documents that contain the letter w in their description.
SQL: SELECT document_name ,  template_id FROM Documents WHERE Document_Description LIKE "%w%"
Database: cre_Doc_Template_Mgt (tables: documents)
Question: What is the document id, template id and description for document named "Robbin CV"?
SQL: SELECT document_id ,  template_id ,  Document_Description FROM Documents WHERE document_name  =  "Robbin CV"
Database: cre_Doc_Template_Mgt (tables: documents)
Question: Return the document id, template id, and description for the document with the name Robbin CV.
SQL: SELECT document_id ,  template_id ,  Document_Description FROM Documents WHERE document_name  =  "Robbin CV"
Database: cre_Doc_Template_Mgt (tables: documents)
Question: How many different templates do all document use?
SQL: SELECT count(DISTINCT template_id) FROM Documents
Database: cre_Doc_Template_Mgt (tables: documents)
Question: Count the number of different templates used for documents.
SQL: SELECT count(DISTINCT template_id) FROM Documents
Database: cre_Doc_Template_Mgt (tables: documents, templates)
Question: How many documents are using the template with type code 'PPT'?
SQL: SELECT count(*) FROM Documents AS T1 JOIN Templates AS T2 ON T1.Template_ID  =  T2.Template_ID WHERE T2.Template_Type_Code  =  'PPT'
Database: cre_Doc_Template_Mgt (tables: documents, templates)
Question: Count the number of documents that use the PPT template type.
SQL: SELECT count(*) FROM Documents AS T1 JOIN Templates AS T2 ON T1.Template_ID  =  T2.Template_ID WHERE T2.Template_Type_Code  =  'PPT'