target-benchmark/spider-queries huggingface dataset:
Database: club_1 (tables: student, club, member_of_club)
Question: Which clubs have one or more members from the city with code "BAL"? Give me the names of the clubs.
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"
Database: club_1 (tables: student, club, member_of_club)
Question: Find the names of the clubs that have at least a member from the city with city code "HOU".
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  =  "HOU"
Database: club_1 (tables: student, club, member_of_club)
Question: Which clubs have one or more members from the city with code "HOU"? Give me the names of the clubs.
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  =  "HOU"
Database: club_1 (tables: student, club, member_of_club)
Question: How many clubs does the student named "Eric Tai" belong to?
SQL: SELECT count(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.fname  =  "Eric" AND t3.lname  =  "Tai"
Database: club_1 (tables: student, club, member_of_club)
Question: Count the number of clubs for which the student named "Eric Tai" is a member.
SQL: SELECT count(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.fname  =  "Eric" AND t3.lname  =  "Tai"
Database: club_1 (tables: student, club, member_of_club)
Question: List the clubs having "Davis Steven" as a member.
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.fname  =  "Davis" AND t3.lname  =  "Steven"
Database: club_1 (tables: student, club, member_of_club)
Question: What are the names of the clubs that have "Davis Steven" as a member?
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.fname  =  "Davis" AND t3.lname  =  "Steven"
Database: club_1 (tables: student, club, member_of_club)
Question: List the clubs that have at least a member with advisor "1121".
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.advisor  =  1121
Database: club_1 (tables: student, club, member_of_club)
Question: Which clubs have one or more members whose advisor is "1121"?
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.advisor  =  1121
Database: club_1 (tables: student, club, member_of_club)
Question: What is the average age of the members of the club "Bootup Baltimore"?
SQL: SELECT avg(t3.age) 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: Find the average age of the members in the club "Bootup Baltimore".
SQL: SELECT avg(t3.age) 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: Find the average age of members of the club "Hopkins Student Enterprises".
SQL: SELECT avg(t3.age) 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: On average, how old are the members in the club "Hopkins Student Enterprises"?
SQL: SELECT avg(t3.age) 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: Retrieve the average age of members of the club "Tennis Club".
SQL: SELECT avg(t3.age) 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: Compute the average age of the members in the club "Tennis Club".
SQL: SELECT avg(t3.age) 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: tracking_grants_for_research (tables: grants, documents, grants)
Question: What are the distinct grant amount for the grants where the documents were sent before '1986-08-26 20:49:27' and grant were ended after '1989-03-16 18:27:16'?
SQL: SELECT T1.grant_amount FROM Grants AS T1 JOIN Documents AS T2 ON T1.grant_id  =  T2.grant_id WHERE T2.sent_date  <  '1986-08-26 20:49:27' INTERSECT SELECT grant_amount FROM grants WHERE grant_end_date  >  '1989-03-16 18:27:16'
Database: tracking_grants_for_research (tables: grants, documents, grants)
Question: What are the different grant amounts for documents sent before '1986-08-26 20:49:27' and after the grant ended on '1989-03-16 18:27:16'?
SQL: SELECT T1.grant_amount FROM Grants AS T1 JOIN Documents AS T2 ON T1.grant_id  =  T2.grant_id WHERE T2.sent_date  <  '1986-08-26 20:49:27' INTERSECT SELECT grant_amount FROM grants WHERE grant_end_date  >  '1989-03-16 18:27:16'
Database: tracking_grants_for_research (tables: project_outcomes, projects)
Question: List the project details of the project both producing patent and paper as outcomes.
SQL: SELECT T1.project_details FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id WHERE T2.outcome_code  =  'Paper' INTERSECT SELECT T1.project_details FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id WHERE T2.outcome_code  =  'Patent'
Database: tracking_grants_for_research (tables: project_outcomes, projects)
Question: What are the details of the project that is producing both patents and papers as outcomes?
SQL: SELECT T1.project_details FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id WHERE T2.outcome_code  =  'Paper' INTERSECT SELECT T1.project_details FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id WHERE T2.outcome_code  =  'Patent'
Database: tracking_grants_for_research (tables: grants, organisations, organisation_types)
Question: What is the total grant amount of the organisations described as research?
SQL: SELECT sum(grant_amount) FROM Grants AS T1 JOIN Organisations AS T2 ON T1.organisation_id  =  T2.organisation_id JOIN organisation_Types AS T3 ON T2.organisation_type  =  T3.organisation_type WHERE T3.organisation_type_description  =  'Research'
Database: tracking_grants_for_research (tables: grants, organisations, organisation_types)
Question: What is the total amount of grant money for research?
SQL: SELECT sum(grant_amount) FROM Grants AS T1 JOIN Organisations AS T2 ON T1.organisation_id  =  T2.organisation_id JOIN organisation_Types AS T3 ON T2.organisation_type  =  T3.organisation_type WHERE T3.organisation_type_description  =  'Research'
Database: tracking_grants_for_research (tables: project_staff)
Question: List from which date and to which date these staff work: project staff of the project which hires the most staffs
SQL: SELECT date_from ,  date_to FROM Project_Staff WHERE project_id IN( SELECT project_id FROM Project_Staff GROUP BY project_id ORDER BY count(*) DESC LIMIT 1 ) UNION SELECT date_from ,  date_to FROM Project_Staff WHERE role_code  =  'leader'
Database: tracking_grants_for_research (tables: project_staff)
Question: From what date and to what date do the staff work on a project that has the most staff and has staff in a leader role?
SQL: SELECT date_from ,  date_to FROM Project_Staff WHERE project_id IN( SELECT project_id FROM Project_Staff GROUP BY project_id ORDER BY count(*) DESC LIMIT 1 ) UNION SELECT date_from ,  date_to FROM Project_Staff WHERE role_code  =  'leader'
Database: tracking_grants_for_research (tables: grants, organisations)
Question: Find the organisation ids and details of the organisations which are involved in
SQL: SELECT T2.organisation_id ,  T2.organisation_details FROM Grants AS T1 JOIN Organisations AS T2 ON T1.organisation_id  =  T2.organisation_id GROUP BY T2.organisation_id HAVING sum(T1.grant_amount)  >  6000
Database: tracking_grants_for_research (tables: grants, organisations)
Question: What are the ids and details for all organizations that have grants of more than 6000 dollars?
SQL: SELECT T2.organisation_id ,  T2.organisation_details FROM Grants AS T1 JOIN Organisations AS T2 ON T1.organisation_id  =  T2.organisation_id GROUP BY T2.organisation_id HAVING sum(T1.grant_amount)  >  6000
Database: tracking_grants_for_research (tables: organisations, research_staff)
Question: What is the organisation type and id of the organisation which has the most number of research staff?
SQL: SELECT T1.organisation_type ,  T1.organisation_id FROM Organisations AS T1 JOIN Research_Staff AS T2 ON T1.organisation_id  =  T2.employer_organisation_id GROUP BY T1.organisation_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: organisations, research_staff)
Question: What is the type and id of the organization that has the most research staff?
SQL: SELECT T1.organisation_type ,  T1.organisation_id FROM Organisations AS T1 JOIN Research_Staff AS T2 ON T1.organisation_id  =  T2.employer_organisation_id GROUP BY T1.organisation_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: organisations, research_staff)
Question: Which organisation type hires most research staff?
SQL: SELECT T1.organisation_type FROM Organisations AS T1 JOIN Research_Staff AS T2 ON T1.organisation_id  =  T2.employer_organisation_id GROUP BY T1.organisation_type ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: organisations, research_staff)
Question: What is the type of the organization with the most research staff?
SQL: SELECT T1.organisation_type FROM Organisations AS T1 JOIN Research_Staff AS T2 ON T1.organisation_id  =  T2.employer_organisation_id GROUP BY T1.organisation_type ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: grants, documents, organisation_types, organisations)
Question: Find out the send dates of the documents with the grant amount of more than 5000 were granted by organisation type described
SQL: SELECT T1.sent_date FROM documents AS T1 JOIN Grants AS T2 ON T1.grant_id  =  T2.grant_id JOIN Organisations AS T3 ON T2.organisation_id  =  T3.organisation_id JOIN organisation_Types AS T4 ON T3.organisation_type  =  T4.organisation_type WHERE T2.grant_amount  >  5000 AND T4.organisation_type_description  =  'Research'
Database: tracking_grants_for_research (tables: grants, documents, organisation_types, organisations)
Question: What are the send dates for all documents that have a grant amount of more than 5000 and are involved in research?
SQL: SELECT T1.sent_date FROM documents AS T1 JOIN Grants AS T2 ON T1.grant_id  =  T2.grant_id JOIN Organisations AS T3 ON T2.organisation_id  =  T3.organisation_id JOIN organisation_Types AS T4 ON T3.organisation_type  =  T4.organisation_type WHERE T2.grant_amount  >  5000 AND T4.organisation_type_description  =  'Research'
Database: tracking_grants_for_research (tables: grants, documents, document_types)
Question: What are the response received dates for the documents described as 'Regular' or granted with more than 100?
SQL: SELECT T1.response_received_date FROM Documents AS T1 JOIN Document_Types AS T2 ON T1.document_type_code  =  T2.document_type_code JOIN Grants AS T3 ON T1.grant_id  =  T3.grant_id WHERE T2.document_description  =  'Regular' OR T3.grant_amount  >  100
Database: tracking_grants_for_research (tables: grants, documents, document_types)
Question: What is the response received date for the document described as Regular that was granted more than 100 dollars?
SQL: SELECT T1.response_received_date FROM Documents AS T1 JOIN Document_Types AS T2 ON T1.document_type_code  =  T2.document_type_code JOIN Grants AS T3 ON T1.grant_id  =  T3.grant_id WHERE T2.document_description  =  'Regular' OR T3.grant_amount  >  100
Database: tracking_grants_for_research (tables: project_staff, projects)
Question: List the project details of the projects which did not hire any staff for a researcher role.
SQL: SELECT project_details FROM Projects WHERE project_id NOT IN ( SELECT project_id FROM Project_Staff WHERE role_code  =  'researcher' )
Database: tracking_grants_for_research (tables: project_staff, projects)
Question: What are the details for all projects that did not hire any staff in a research role?
SQL: SELECT project_details FROM Projects WHERE project_id NOT IN ( SELECT project_id FROM Project_Staff WHERE role_code  =  'researcher' )
Database: tracking_grants_for_research (tables: tasks, project_outcomes, projects)
Question: What are the task details, task id and project id for the projects which are detailed as 'omnis' or  have more than 2 outcomes?
SQL: SELECT T1.task_details ,  T1.task_id ,  T2.project_id FROM Tasks AS T1 JOIN Projects AS T2 ON T1.project_id  =  T2.project_id WHERE T2.project_details  =  'omnis' UNION SELECT T1.task_details ,  T1.task_id ,  T2.project_id FROM Tasks AS T1 JOIN Projects AS T2 ON T1.project_id  =  T2.project_id JOIN Project_outcomes AS T3 ON T2.project_id  =  T3.project_id GROUP BY T2.project_id HAVING count(*)  >  2
Database: tracking_grants_for_research (tables: tasks, project_outcomes, projects)
Question: What are the task details, task ids, and project ids for the progrects that are detailed as 'omnis' or have at least 3 outcomes?
SQL: SELECT T1.task_details ,  T1.task_id ,  T2.project_id FROM Tasks AS T1 JOIN Projects AS T2 ON T1.project_id  =  T2.project_id WHERE T2.project_details  =  'omnis' UNION SELECT T1.task_details ,  T1.task_id ,  T2.project_id FROM Tasks AS T1 JOIN Projects AS T2 ON T1.project_id  =  T2.project_id JOIN Project_outcomes AS T3 ON T2.project_id  =  T3.project_id GROUP BY T2.project_id HAVING count(*)  >  2
Database: tracking_grants_for_research (tables: project_staff)
Question: When do all the researcher role staff start to work, and when do they stop working?
SQL: SELECT date_from ,  date_to FROM Project_Staff WHERE role_code  =  'researcher'
Database: tracking_grants_for_research (tables: project_staff)
Question: When did researchers start and stop working?
SQL: SELECT date_from ,  date_to FROM Project_Staff WHERE role_code  =  'researcher'
Database: tracking_grants_for_research (tables: project_staff)
Question: How many kinds of roles are there for the staff?
SQL: SELECT count(DISTINCT role_code) FROM Project_Staff
Database: tracking_grants_for_research (tables: project_staff)
Question: How many different roles are there on the project staff?
SQL: SELECT count(DISTINCT role_code) FROM Project_Staff
Database: tracking_grants_for_research (tables: grants)
Question: What is the total amount of grants given by each organisations? Also list the organisation id.
SQL: SELECT sum(grant_amount) ,  organisation_id FROM Grants GROUP BY organisation_id
Database: tracking_grants_for_research (tables: grants)
Question: What is the total amount of grant money given to each organization and what is its id?
SQL: SELECT sum(grant_amount) ,  organisation_id FROM Grants GROUP BY organisation_id
Database: tracking_grants_for_research (tables: research_outcomes, project_outcomes, projects)
Question: List the project details of the projects with the research outcome described with the substring 'Published'.
SQL: SELECT T1.project_details FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id JOIN Research_outcomes AS T3 ON T2.outcome_code  =  T3.outcome_code WHERE T3.outcome_description LIKE '%Published%'
Database: tracking_grants_for_research (tables: research_outcomes, project_outcomes, projects)
Question: What are the details for the project whose research has been published?
SQL: SELECT T1.project_details FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id JOIN Research_outcomes AS T3 ON T2.outcome_code  =  T3.outcome_code WHERE T3.outcome_description LIKE '%Published%'
Database: tracking_grants_for_research (tables: project_staff, projects)
Question: How many staff does each project has? List the project id and the number in an ascending order.
SQL: SELECT T1.project_id ,  count(*) FROM Project_Staff AS T1 JOIN Projects AS T2 ON T1.project_id  =  T2.project_id GROUP BY T1.project_id ORDER BY count(*) ASC
Database: tracking_grants_for_research (tables: project_staff, projects)
Question: For each project id, how many staff does it have? List them in increasing order.
SQL: SELECT T1.project_id ,  count(*) FROM Project_Staff AS T1 JOIN Projects AS T2 ON T1.project_id  =  T2.project_id GROUP BY T1.project_id ORDER BY count(*) ASC
Database: tracking_grants_for_research (tables: staff_roles)
Question: What is the complete description of the researcher role.
SQL: SELECT role_description FROM Staff_Roles WHERE role_code  =  'researcher'
Database: tracking_grants_for_research (tables: staff_roles)
Question: What is the complete description of the job of a researcher?
SQL: SELECT role_description FROM Staff_Roles WHERE role_code  =  'researcher'
Database: tracking_grants_for_research (tables: project_staff)
Question: When did the first staff for the projects started working?
SQL: SELECT date_from FROM Project_Staff ORDER BY date_from ASC LIMIT 1
Database: tracking_grants_for_research (tables: project_staff)
Question: When did the first staff member start working?
SQL: SELECT date_from FROM Project_Staff ORDER BY date_from ASC LIMIT 1
Database: tracking_grants_for_research (tables: project_outcomes, projects)
Question: Which project made the most number of outcomes? List the project details and the project id.
SQL: SELECT T1.project_details ,  T1.project_id FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id GROUP BY T1.project_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: project_outcomes, projects)
Question: What are the details and id of the project with the most outcomes?
SQL: SELECT T1.project_details ,  T1.project_id FROM Projects AS T1 JOIN Project_outcomes AS T2 ON T1.project_id  =  T2.project_id GROUP BY T1.project_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: projects, project_outcomes)
Question: Which projects have no outcome? List the project details.
SQL: SELECT project_details FROM Projects WHERE project_id NOT IN ( SELECT project_id FROM Project_outcomes )
Database: tracking_grants_for_research (tables: projects, project_outcomes)
Question: What are the details of the project with no outcomes?
SQL: SELECT project_details FROM Projects WHERE project_id NOT IN ( SELECT project_id FROM Project_outcomes )
Database: tracking_grants_for_research (tables: organisations, research_staff)
Question: Which organisation hired the most number of research staff? List the organisation id, type and detail.
SQL: SELECT T1.organisation_id ,  T1.organisation_type ,  T1.organisation_details FROM Organisations AS T1 JOIN Research_Staff AS T2 ON T1.organisation_id  =  T2.employer_organisation_id GROUP BY T1.organisation_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: organisations, research_staff)
Question: What are the ids, types, and details of the organization with the most research staff?
SQL: SELECT T1.organisation_id ,  T1.organisation_type ,  T1.organisation_details FROM Organisations AS T1 JOIN Research_Staff AS T2 ON T1.organisation_id  =  T2.employer_organisation_id GROUP BY T1.organisation_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: project_staff, staff_roles, project_outcomes)
Question: Show the role description and the id of the project staff involved in most number of project outcomes?
SQL: SELECT T1.role_description ,  T2.staff_id FROM Staff_Roles AS T1 JOIN Project_Staff AS T2 ON T1.role_code  =  T2.role_code JOIN Project_outcomes AS T3 ON T2.project_id  =  T3.project_id GROUP BY T2.staff_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: project_staff, staff_roles, project_outcomes)
Question: For each staff id, what is the description of the role that is involved with the most number of projects?
SQL: SELECT T1.role_description ,  T2.staff_id FROM Staff_Roles AS T1 JOIN Project_Staff AS T2 ON T1.role_code  =  T2.role_code JOIN Project_outcomes AS T3 ON T2.project_id  =  T3.project_id GROUP BY T2.staff_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: document_types)
Question: Which document type is described with the prefix 'Initial'?
SQL: SELECT document_type_code FROM Document_Types WHERE document_description LIKE 'Initial%'
Database: tracking_grants_for_research (tables: document_types)
Question: What is the type of the document whose description starts with the word 'Initial'?
SQL: SELECT document_type_code FROM Document_Types WHERE document_description LIKE 'Initial%'
Database: tracking_grants_for_research (tables: grants, documents, document_types)
Question: For grants with both documents described as 'Regular' and documents described as 'Initial Application', list its start date.
SQL: SELECT T1.grant_start_date FROM Grants AS T1 JOIN Documents AS T2 ON T1.grant_id  =  T2.grant_id JOIN Document_Types AS T3 ON T2.document_type_code  =  T3.document_type_code WHERE T3.document_description  =  'Regular' INTERSECT SELECT T1.grant_start_date FROM Grants AS T1 JOIN Documents AS T2 ON T1.grant_id  =  T2.grant_id JOIN Document_Types AS T3 ON T2.document_type_code  =  T3.document_type_code WHERE T3.document_description  =  'Initial Application'
Database: tracking_grants_for_research (tables: grants, documents, document_types)
Question: For grants that have descriptions of Regular and Initial Applications, what are their start dates?
SQL: SELECT T1.grant_start_date FROM Grants AS T1 JOIN Documents AS T2 ON T1.grant_id  =  T2.grant_id JOIN Document_Types AS T3 ON T2.document_type_code  =  T3.document_type_code WHERE T3.document_description  =  'Regular' INTERSECT SELECT T1.grant_start_date FROM Grants AS T1 JOIN Documents AS T2 ON T1.grant_id  =  T2.grant_id JOIN Document_Types AS T3 ON T2.document_type_code  =  T3.document_type_code WHERE T3.document_description  =  'Initial Application'
Database: tracking_grants_for_research (tables: documents)
Question: How many documents can one grant have at most? List the grant id and number.
SQL: SELECT grant_id ,  count(*) FROM Documents GROUP BY grant_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: documents)
Question: For each grant id, how many documents does it have, and which one has the most?
SQL: SELECT grant_id ,  count(*) FROM Documents GROUP BY grant_id ORDER BY count(*) DESC LIMIT 1
Database: tracking_grants_for_research (tables: organisations, organisation_types)
Question: Find the organisation type description of the organisation detailed as 'quo'.
SQL: SELECT T1.organisation_type_description FROM organisation_Types AS T1 JOIN Organisations AS T2 ON T1.organisation_type  =  T2.organisation_type WHERE T2.organisation_details  =  'quo'
Database: tracking_grants_for_research (tables: organisations, organisation_types)
Question: What is the type description of the organization whose detail is listed as 'quo'?
SQL: SELECT T1.organisation_type_description FROM organisation_Types AS T1 JOIN Organisations AS T2 ON T1.organisation_type  =  T2.organisation_type WHERE T2.organisation_details  =  'quo'