target-benchmark/spider-queries huggingface dataset:
Database: cre_Docs_and_Epenses (tables: documents, projects)
Question: Show the document name and the document date for all documents on project with details 'Graph Database project'.
SQL: SELECT document_name ,  document_date FROM Documents AS T1 JOIN projects AS T2 ON T1.project_id  =  T2.project_id WHERE T2.project_details  =  'Graph Database project'
Database: cre_Docs_and_Epenses (tables: documents, projects)
Question: What are the names and dates for documents corresponding to project that has the details 'Graph Database project'?
SQL: SELECT document_name ,  document_date FROM Documents AS T1 JOIN projects AS T2 ON T1.project_id  =  T2.project_id WHERE T2.project_details  =  'Graph Database project'
Database: cre_Docs_and_Epenses (tables: documents)
Question: Show project ids and the number of documents in each project.
SQL: SELECT project_id ,  count(*) FROM Documents GROUP BY project_id
Database: cre_Docs_and_Epenses (tables: documents)
Question: How many documents correspond with each project id?
SQL: SELECT project_id ,  count(*) FROM Documents GROUP BY project_id
Database: cre_Docs_and_Epenses (tables: documents)
Question: What is the id of the project with least number of documents?
SQL: SELECT project_id FROM Documents GROUP BY project_id ORDER BY count(*) ASC LIMIT 1
Database: cre_Docs_and_Epenses (tables: documents)
Question: Return the id of the project that has the fewest corresponding documents.
SQL: SELECT project_id FROM Documents GROUP BY project_id ORDER BY count(*) ASC LIMIT 1
Database: cre_Docs_and_Epenses (tables: documents)
Question: Show the ids for projects with at least 2 documents.
SQL: SELECT project_id FROM Documents GROUP BY project_id HAVING count(*)  >=  2
Database: cre_Docs_and_Epenses (tables: documents)
Question: What are project ids of projects that have 2 or more corresponding documents?
SQL: SELECT project_id FROM Documents GROUP BY project_id HAVING count(*)  >=  2
Database: cre_Docs_and_Epenses (tables: documents)
Question: List document type codes and the number of documents in each code.
SQL: SELECT document_type_code ,  count(*) FROM Documents GROUP BY document_type_code
Database: cre_Docs_and_Epenses (tables: documents)
Question: How many documents are there of each type?
SQL: SELECT document_type_code ,  count(*) FROM Documents GROUP BY document_type_code
Database: cre_Docs_and_Epenses (tables: documents)
Question: What is the document type code with most number of documents?
SQL: SELECT document_type_code FROM Documents GROUP BY document_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Docs_and_Epenses (tables: documents)
Question: Return the code of the document type that is most common.
SQL: SELECT document_type_code FROM Documents GROUP BY document_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Docs_and_Epenses (tables: documents)
Question: Show the document type code with fewer than 3 documents.
SQL: SELECT document_type_code FROM Documents GROUP BY document_type_code HAVING count(*)  <  3
Database: cre_Docs_and_Epenses (tables: documents)
Question: What are the codes corresponding to document types for which there are less than 3 documents?
SQL: SELECT document_type_code FROM Documents GROUP BY document_type_code HAVING count(*)  <  3
Database: cre_Docs_and_Epenses (tables: statements, documents)
Question: Show the statement detail and the corresponding document name for the statement with detail 'Private Project'.
SQL: SELECT T1.statement_details ,  T2.document_name FROM Statements AS T1 JOIN Documents AS T2 ON T1.statement_id  =  T2.document_id WHERE T1.statement_details  =  'Private Project'
Database: cre_Docs_and_Epenses (tables: statements, documents)
Question: What are the details for statements with the details 'Private Project', and what are the names of the corresponding documents?
SQL: SELECT T1.statement_details ,  T2.document_name FROM Statements AS T1 JOIN Documents AS T2 ON T1.statement_id  =  T2.document_id WHERE T1.statement_details  =  'Private Project'
Database: cre_Docs_and_Epenses (tables: ref_document_types)
Question: Show all document type codes, document type names, document type descriptions.
SQL: SELECT document_type_code ,  document_type_name ,  document_type_description FROM Ref_document_types
Database: cre_Docs_and_Epenses (tables: ref_document_types)
Question: What are the codes, names, and descriptions of the different document types?
SQL: SELECT document_type_code ,  document_type_name ,  document_type_description FROM Ref_document_types
Database: cre_Docs_and_Epenses (tables: ref_document_types)
Question: What is the document type description for document type named Film?
SQL: SELECT document_type_description FROM Ref_document_types WHERE document_type_name  =  "Film"
Database: cre_Docs_and_Epenses (tables: ref_document_types)
Question: Return the description of the document type name 'Film'.
SQL: SELECT document_type_description FROM Ref_document_types WHERE document_type_name  =  "Film"
Database: cre_Docs_and_Epenses (tables: documents, ref_document_types)
Question: What is the document type name and the document type description and creation date for all the documents?
SQL: SELECT T1.document_type_name ,  T1.document_type_description ,  T2.Document_date FROM Ref_document_types AS T1 JOIN Documents AS T2 ON T1.document_type_code  =  T2.document_type_code
Database: cre_Docs_and_Epenses (tables: documents, ref_document_types)
Question: Return the type name, type description, and date of creation for each document.
SQL: SELECT T1.document_type_name ,  T1.document_type_description ,  T2.Document_date FROM Ref_document_types AS T1 JOIN Documents AS T2 ON T1.document_type_code  =  T2.document_type_code
Database: cre_Docs_and_Epenses (tables: projects)
Question: Show the number of projects.
SQL: SELECT count(*) FROM Projects
Database: cre_Docs_and_Epenses (tables: projects)
Question: How many projects are there?
SQL: SELECT count(*) FROM Projects
Database: cre_Docs_and_Epenses (tables: projects)
Question: List ids and details for all projects.
SQL: SELECT project_id ,  project_details FROM Projects
Database: cre_Docs_and_Epenses (tables: projects)
Question: What are the ids and details for each project?
SQL: SELECT project_id ,  project_details FROM Projects
Database: cre_Docs_and_Epenses (tables: documents, projects)
Question: What is the project id and detail for the project with at least two documents?
SQL: SELECT T1.project_id ,  T1.project_details FROM Projects AS T1 JOIN Documents AS T2 ON T1.project_id  =  T2.project_id GROUP BY T1.project_id HAVING count(*)  >  2
Database: cre_Docs_and_Epenses (tables: documents, projects)
Question: Return the ids and details corresponding to projects for which there are more than two documents.
SQL: SELECT T1.project_id ,  T1.project_details FROM Projects AS T1 JOIN Documents AS T2 ON T1.project_id  =  T2.project_id GROUP BY T1.project_id HAVING count(*)  >  2
Database: cre_Docs_and_Epenses (tables: documents, projects)
Question: What is the project detail for the project with document "King Book"?
SQL: SELECT T1.project_details FROM Projects AS T1 JOIN Documents AS T2 ON T1.project_id  =  T2.project_id WHERE T2.document_name  =  "King Book"
Database: cre_Docs_and_Epenses (tables: documents, projects)
Question: Give the details of the project with the document name 'King Book'.
SQL: SELECT T1.project_details FROM Projects AS T1 JOIN Documents AS T2 ON T1.project_id  =  T2.project_id WHERE T2.document_name  =  "King Book"
Database: cre_Docs_and_Epenses (tables: ref_budget_codes)
Question: How many budget types do we have?
SQL: SELECT count(*) FROM Ref_budget_codes
Database: cre_Docs_and_Epenses (tables: ref_budget_codes)
Question: Count the number of budget codes.
SQL: SELECT count(*) FROM Ref_budget_codes
Database: cre_Docs_and_Epenses (tables: ref_budget_codes)
Question: List all budget type codes and descriptions.
SQL: SELECT budget_type_code ,  budget_type_description FROM Ref_budget_codes
Database: cre_Docs_and_Epenses (tables: ref_budget_codes)
Question: What are the type codes and descriptions of each budget type?
SQL: SELECT budget_type_code ,  budget_type_description FROM Ref_budget_codes
Database: cre_Docs_and_Epenses (tables: ref_budget_codes)
Question: What is the description for the budget type with code ORG?
SQL: SELECT budget_type_description FROM Ref_budget_codes WHERE budget_type_code  =  "ORG"
Database: cre_Docs_and_Epenses (tables: ref_budget_codes)
Question: Return the description of the budget type that has the code ORG.
SQL: SELECT budget_type_description FROM Ref_budget_codes WHERE budget_type_code  =  "ORG"
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: How many documents have expenses?
SQL: SELECT count(*) FROM Documents_with_expenses
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: Count the number of documents with expenses.
SQL: SELECT count(*) FROM Documents_with_expenses
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: What are the document ids for the budget type code 'SF'?
SQL: SELECT document_id FROM Documents_with_expenses WHERE budget_type_code  =  'SF'
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: Give the ids of documents with expenses that have the budget code 'SF'.
SQL: SELECT document_id FROM Documents_with_expenses WHERE budget_type_code  =  'SF'
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, ref_budget_codes)
Question: Show the budget type code and description and the corresponding document id.
SQL: SELECT T2.budget_type_code ,  T2.budget_type_description ,  T1.document_id FROM Documents_with_expenses AS T1 JOIN Ref_budget_codes AS T2 ON T1.budget_type_code  =  T2.budget_type_code
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, ref_budget_codes)
Question: Return the budget type codes, budget type descriptions and document ids for documents with expenses.
SQL: SELECT T2.budget_type_code ,  T2.budget_type_description ,  T1.document_id FROM Documents_with_expenses AS T1 JOIN Ref_budget_codes AS T2 ON T1.budget_type_code  =  T2.budget_type_code
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, ref_budget_codes)
Question: Show ids for all documents with budget types described as 'Government'.
SQL: SELECT T1.document_id FROM Documents_with_expenses AS T1 JOIN Ref_Budget_Codes AS T2 ON T1.Budget_Type_code  =  T2.Budget_Type_code WHERE T2.budget_type_Description  =  "Government"
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, ref_budget_codes)
Question: Give the ids for documents that have the budget description 'Government'.
SQL: SELECT T1.document_id FROM Documents_with_expenses AS T1 JOIN Ref_Budget_Codes AS T2 ON T1.Budget_Type_code  =  T2.Budget_Type_code WHERE T2.budget_type_Description  =  "Government"
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: Show budget type codes and the number of documents in each budget type.
SQL: SELECT budget_type_code ,  count(*) FROM Documents_with_expenses GROUP BY budget_type_code
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: What are the different budget type codes, and how many documents are there for each?
SQL: SELECT budget_type_code ,  count(*) FROM Documents_with_expenses GROUP BY budget_type_code
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: What is the budget type code with most number of documents.
SQL: SELECT budget_type_code FROM Documents_with_expenses GROUP BY budget_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Docs_and_Epenses (tables: documents_with_expenses)
Question: Give the budget type code that is most common among documents with expenses.
SQL: SELECT budget_type_code FROM Documents_with_expenses GROUP BY budget_type_code ORDER BY count(*) DESC LIMIT 1
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: What are the ids of documents which don't have expense budgets?
SQL: SELECT document_id FROM Documents EXCEPT SELECT document_id FROM Documents_with_expenses
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: Return the ids of documents that do not have expenses.
SQL: SELECT document_id FROM Documents EXCEPT SELECT document_id FROM Documents_with_expenses
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: Show ids for all documents in type CV without expense budgets.
SQL: SELECT document_id FROM Documents WHERE document_type_code  =  "CV" EXCEPT SELECT document_id FROM Documents_with_expenses
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: What are the ids of documents with the type code CV that do not have expenses.
SQL: SELECT document_id FROM Documents WHERE document_type_code  =  "CV" EXCEPT SELECT document_id FROM Documents_with_expenses
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: What are the ids of documents with letter 's' in the name with any expense budgets.
SQL: SELECT T1.document_id FROM Documents AS T1 JOIN Documents_with_expenses AS T2 ON T1.document_id  =  T2.document_id WHERE T1.document_name LIKE '%s%'
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: Give the ids of documents that have expenses and contain the letter s in their names.
SQL: SELECT T1.document_id FROM Documents AS T1 JOIN Documents_with_expenses AS T2 ON T1.document_id  =  T2.document_id WHERE T1.document_name LIKE '%s%'
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: How many documents do not have any expense?
SQL: SELECT count(*) FROM Documents WHERE document_id NOT IN ( SELECT document_id FROM Documents_with_expenses )
Database: cre_Docs_and_Epenses (tables: documents_with_expenses, documents)
Question: Count the number of documents that do not have expenses.
SQL: SELECT count(*) FROM Documents WHERE document_id NOT IN ( SELECT document_id FROM Documents_with_expenses )
Database: cre_Docs_and_Epenses (tables: documents, documents_with_expenses)
Question: What are the dates for the documents with both 'GV' type and 'SF' type expenses?
SQL: SELECT T1.document_date FROM Documents AS T1 JOIN Documents_with_Expenses AS T2 ON T1.document_id  =  T2.document_id WHERE T2.budget_type_code  =  'GV' INTERSECT SELECT T1.document_date FROM Documents AS T1 JOIN Documents_with_Expenses AS T2 ON T1.document_id  =  T2.document_id WHERE T2.budget_type_code  =  'SF'
Database: cre_Docs_and_Epenses (tables: documents, documents_with_expenses)
Question: Give the dates of creation for documents that have both budget type codes 'GV' and 'SF'.
SQL: SELECT T1.document_date FROM Documents AS T1 JOIN Documents_with_Expenses AS T2 ON T1.document_id  =  T2.document_id WHERE T2.budget_type_code  =  'GV' INTERSECT SELECT T1.document_date FROM Documents AS T1 JOIN Documents_with_Expenses AS T2 ON T1.document_id  =  T2.document_id WHERE T2.budget_type_code  =  'SF'
Database: cre_Docs_and_Epenses (tables: accounts)
Question: What are the account details with the largest value or with value having char '5' in it?
SQL: SELECT max(Account_details) FROM Accounts UNION SELECT Account_details FROM Accounts WHERE Account_details LIKE "%5%"
Database: cre_Docs_and_Epenses (tables: accounts)
Question: Return the account details with the greatest value, as well as those that include the character 5.
SQL: SELECT max(Account_details) FROM Accounts UNION SELECT Account_details FROM Accounts WHERE Account_details LIKE "%5%"
Database: scientist_1 (tables: scientists)
Question: Find the total number of scientists.
SQL: SELECT count(*) FROM scientists
Database: scientist_1 (tables: scientists)
Question: How many scientists are there?
SQL: SELECT count(*) FROM scientists
Database: scientist_1 (tables: projects)
Question: Find the total hours of all projects.
SQL: SELECT sum(hours) FROM projects
Database: scientist_1 (tables: projects)
Question: What is the total number of hours for all projects?
SQL: SELECT sum(hours) FROM projects
Database: scientist_1 (tables: assignedto)
Question: How many different scientists are assigned to any project?
SQL: SELECT count(DISTINCT scientist) FROM assignedto
Database: scientist_1 (tables: assignedto)
Question: Count the number of different scientists assigned to any project.
SQL: SELECT count(DISTINCT scientist) FROM assignedto
Database: scientist_1 (tables: projects)
Question: Find the number of distinct projects.
SQL: SELECT count(DISTINCT name) FROM projects
Database: scientist_1 (tables: projects)
Question: How many different projects are there?
SQL: SELECT count(DISTINCT name) FROM projects
Database: scientist_1 (tables: projects)
Question: Find the average hours of all projects.
SQL: SELECT avg(hours) FROM projects
Database: scientist_1 (tables: projects)
Question: What is the average hours across all projects?
SQL: SELECT avg(hours) FROM projects
Database: scientist_1 (tables: projects)
Question: Find the name of project that continues for the longest time.
SQL: SELECT name FROM projects ORDER BY hours DESC LIMIT 1
Database: scientist_1 (tables: projects)
Question: What is the name of the project with the most hours?
SQL: SELECT name FROM projects ORDER BY hours DESC LIMIT 1
Database: scientist_1 (tables: projects)
Question: List the name of all projects that are operated longer than the average working hours of all projects.
SQL: SELECT name FROM projects WHERE hours  >  (SELECT avg(hours) FROM projects)
Database: scientist_1 (tables: projects)
Question: What are the names of projects that have taken longer than the average number of hours for all projects?
SQL: SELECT name FROM projects WHERE hours  >  (SELECT avg(hours) FROM projects)
Database: scientist_1 (tables: assignedto, projects)
Question: Find the name and hours of project that has the most number of scientists.
SQL: SELECT T1.name ,  T1.hours FROM projects AS T1 JOIN assignedto AS T2 ON T1.code  =  T2.project GROUP BY T2.project ORDER BY count(*) DESC LIMIT 1
Database: scientist_1 (tables: assignedto, projects)
Question: What is the name and hours for the project which has the most scientists assigned to it?
SQL: SELECT T1.name ,  T1.hours FROM projects AS T1 JOIN assignedto AS T2 ON T1.code  =  T2.project GROUP BY T2.project ORDER BY count(*) DESC LIMIT 1
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: Find the name of the project for which a scientist whose name contains ‘Smith’ is assigned to.
SQL: SELECT T2.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T3.name LIKE '%Smith%'
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: What is the name of the project that has a scientist assigned to it whose name contains 'Smith'?
SQL: SELECT T2.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T3.name LIKE '%Smith%'
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: Find the total hours of the projects that scientists named Michael Rogers or Carol Smith are assigned to.
SQL: SELECT sum(T2.hours) FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T3.name  =  'Michael Rogers' OR T3.name  =  'Carol Smith'
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: What is the sum of hours for projects that scientists with the name Michael Rogers or Carol Smith are assigned to?
SQL: SELECT sum(T2.hours) FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T3.name  =  'Michael Rogers' OR T3.name  =  'Carol Smith'
Database: scientist_1 (tables: projects)
Question: Find the name of projects that require between 100 and 300 hours of work.
SQL: SELECT name FROM projects WHERE hours BETWEEN 100 AND 300
Database: scientist_1 (tables: projects)
Question: What are the names of projects that require between 100 and 300 hours?
SQL: SELECT name FROM projects WHERE hours BETWEEN 100 AND 300
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: Find the name of the scientist who worked on both a project named 'Matter of Time' and a project named 'A Puzzling Parallax'.
SQL: SELECT T3.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T2.name  =  'Matter of Time' INTERSECT SELECT T3.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T2.name  =  'A Puzzling Parallax'
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: What are the names of any scientists who worked on projects named 'Matter of Time' and 'A Puzzling Pattern'?
SQL: SELECT T3.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T2.name  =  'Matter of Time' INTERSECT SELECT T3.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T2.name  =  'A Puzzling Parallax'
Database: scientist_1 (tables: scientists)
Question: List the names of all scientists sorted in alphabetical order.
SQL: SELECT name FROM scientists ORDER BY name
Database: scientist_1 (tables: scientists)
Question: What are the names of all the scientists in alphabetical order?
SQL: SELECT name FROM scientists ORDER BY name
Database: scientist_1 (tables: assignedto, projects)
Question: Find the number of scientists involved for each project name.
SQL: SELECT count(*) ,  T1.name FROM projects AS T1 JOIN assignedto AS T2 ON T1.code  =  T2.project GROUP BY T1.name
Database: scientist_1 (tables: assignedto, projects)
Question: What are the naems of all the projects, and how many scientists were assigned to each of them?
SQL: SELECT count(*) ,  T1.name FROM projects AS T1 JOIN assignedto AS T2 ON T1.code  =  T2.project GROUP BY T1.name
Database: scientist_1 (tables: assignedto, projects)
Question: Find the number of scientists involved for the projects that require more than 300 hours.
SQL: SELECT count(*) ,  T1.name FROM projects AS T1 JOIN assignedto AS T2 ON T1.code  =  T2.project WHERE T1.hours  >  300 GROUP BY T1.name
Database: scientist_1 (tables: assignedto, projects)
Question: What are the names of projects that require more than 300 hours, and how many scientists are assigned to each?
SQL: SELECT count(*) ,  T1.name FROM projects AS T1 JOIN assignedto AS T2 ON T1.code  =  T2.project WHERE T1.hours  >  300 GROUP BY T1.name
Database: scientist_1 (tables: scientists, assignedto)
Question: Find the number of projects which each scientist is working on and scientist's name.
SQL: SELECT count(*) ,  T1.name FROM scientists AS T1 JOIN assignedto AS T2 ON T1.ssn  =  T2.scientist GROUP BY T1.name
Database: scientist_1 (tables: scientists, assignedto)
Question: What are the names of the scientists, and how many projects are each of them working on?
SQL: SELECT count(*) ,  T1.name FROM scientists AS T1 JOIN assignedto AS T2 ON T1.ssn  =  T2.scientist GROUP BY T1.name
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: Find the SSN and name of scientists who are assigned to the project with the longest hours.
SQL: SELECT T3.ssn ,  T3.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T2.hours  =  (SELECT max(hours) FROM projects)
Database: scientist_1 (tables: assignedto, scientists, projects)
Question: What are the SSN and names of scientists working on the project with the most hours?
SQL: SELECT T3.ssn ,  T3.name FROM assignedto AS T1 JOIN projects AS T2 ON T1.project  =  T2.code JOIN scientists AS T3 ON T1.scientist  =  T3.SSN WHERE T2.hours  =  (SELECT max(hours) FROM projects)
Database: scientist_1 (tables: assignedto, scientists)
Question: Find the name of scientists who are assigned to some project.
SQL: SELECT T2.name FROM assignedto AS T1 JOIN scientists AS T2 ON T1.scientist  =  T2.ssn