Datasets:

Modalities:
Text
Formats:
arrow
Size:
< 1K
ArXiv:
Libraries:
Datasets
License:
Dataset Viewer
Auto-converted to Parquet Duplicate
db_id
stringlengths
4
26
query
stringlengths
71
316
question
stringlengths
38
134
db_description
stringlengths
161
306
gold_output
stringlengths
17
26.6k
question_id
stringlengths
3
13
var_values
listlengths
0
3
is_backup
bool
1 class
num_alternatives
int64
1
1
identifier_names
listlengths
0
0
processed_sql
stringlengths
71
316
tool_id
stringlengths
2
4
documentation
stringlengths
323
696
alternate_tool_ids
listlengths
2
2
cluster_id
stringlengths
0
12
hr_1
SELECT * FROM employees WHERE NOT department_id IN (SELECT department_id FROM departments WHERE manager_id BETWEEN 100 AND 200)
What are the ids for employees who do not work in departments with managers that have ids between 0 and 103?
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"EMPLOYEE_ID": 108, "FIRST_NAME": "Nancy", "LAST_NAME": "Greenberg", "EMAIL": "NGREENBE", "PHONE_NUMBER": "515.124.4569", "HIRE_DATE": "1987-06-25", "JOB_ID": "FI_MGR", "SALARY": 12000, "COMMISSION_PCT": 0, "MANAGER_ID": 101, "DEPARTMENT_ID": 100}, {"EMPLOYEE_ID": 109, "FIRST_NAME": "Daniel", "LAST_NAME": "Faviet", "...
augmented_121
[ "0", "103" ]
false
1
[]
SELECT * FROM employees WHERE NOT department_id IN (SELECT department_id FROM departments WHERE manager_id BETWEEN ? AND ?)
1628
{"type": "function", "function": {"name": "function_1628", "description": "Get information about employees who do not belong to departments with managers within a specified range of manager IDs. The data is retrieved from a human resources management system database.", "parameters": {"type": "object", "properties": {"c...
[ "1626", "1627" ]
cluster_1599
wine_1
SELECT Name FROM WINE WHERE Price > (SELECT MAX(Price) FROM WINE WHERE YEAR = 2006)
What are the names of wines that are more expensive then all wines made in the year 2004?
This SQLite database stores information about wines, including their characteristics and ratings, as well as related data on grape varieties and wine appellations, with relationships established between these entities to facilitate querying and analysis.
[{"Name": "Pritchard Hill"}, {"Name": "Reserve"}, {"Name": "Annum"}, {"Name": "Beckstoffer To Kalon Vineyard"}, {"Name": "Coliseum Block"}, {"Name": "1886"}, {"Name": "Beckstoffer To Kalon Vineyard"}, {"Name": "Couer de Valee"}, {"Name": "Five Sisters"}, {"Name": "Eddies Patch"}, {"Name": "Darius II"}, {"Name": "Cabern...
augmented_498
[ "2004" ]
false
1
[]
SELECT Name FROM WINE WHERE Price > (SELECT MAX(Price) FROM WINE WHERE YEAR = ?)
2874
{"type": "function", "function": {"name": "function_2874", "description": "Get the names of wines with prices higher than the maximum price of wines from a specific year. The wine_1 database stores information about wines, including their characteristics and ratings.", "parameters": {"type": "object", "properties": {"b...
[ "2872", "2873" ]
cluster_6989
aircraft
SELECT name FROM pilot WHERE NOT pilot_id IN (SELECT Winning_Pilot FROM MATCH WHERE country = 'Australia')
What are the names of the pilots that have not won any matches in United Arab Emirates?
This SQLite database appears to store information about pilots, aircraft, and airports, as well as match data, with relationships established between winning pilots and aircraft, and between airports and the aircraft that operate from them.
[{"Name": "Katheryn Gorczany IV"}, {"Name": "Mr. Cristian Halvorson II"}, {"Name": "Ayana Spencer"}, {"Name": "Ellen Ledner III"}, {"Name": "Elisha Hickle V"}, {"Name": "Dr. Jade Bradtke V"}, {"Name": "Winnifred Boyle"}, {"Name": "Della Lindgren"}, {"Name": "Maxwell Graham"}, {"Name": "Blaise Muller"}, {"Name": "Baylee...
augmented_21
[ "United Arab Emirates" ]
false
1
[]
SELECT name FROM pilot WHERE NOT pilot_id IN (SELECT Winning_Pilot FROM MATCH WHERE country = ?)
130
{"type": "function", "function": {"name": "function_130", "description": "Get the names of pilots who have not won a match in a specific country. The function uses data from the `aircraft` database, which stores information about pilots, aircraft, and airports, as well as match data.", "parameters": {"type": "object", ...
[ "128", "129" ]
cluster_114
manufactory_1
SELECT name FROM manufacturers WHERE revenue < (SELECT MIN(revenue) FROM manufacturers WHERE headquarter = 'Austin')
Find the name of companies whose revenue is smaller than the revenue of all companies based in Austin.
This SQLite database stores information about computer hardware manufacturers and their products, including manufacturer details such as headquarters and revenue, and product details such as name and price.
[{"Name": "Hewlett-Packard"}, {"Name": "Winchester"}]
4874
[ "Austin" ]
false
1
[]
SELECT name FROM manufacturers WHERE revenue < (SELECT MIN(revenue) FROM manufacturers WHERE headquarter = ?)
661
{"type": "function", "function": {"name": "function_661", "description": "Get the names of manufacturers with revenue lower than the minimum revenue of manufacturers with a specific headquarter. The data is retrieved from the `manufactory_1` database, which stores information about computer hardware manufacturers and t...
[ "659", "660" ]
dorm_1
SELECT fname, lname FROM student WHERE major <> (SELECT major FROM student GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1)
What is the first and last name of the students who are not in the largest major?
This SQLite database manages information about university students, including their personal details, dorm assignments, and the amenities available in each dorm.
[{"Fname": "Ian", "LName": "Thornton"}, {"Fname": "George", "LName": "Andreou"}, {"Fname": "Michael", "LName": "Woods"}, {"Fname": "David", "LName": "Shieber"}, {"Fname": "Stacy", "LName": "Prater"}, {"Fname": "Mark", "LName": "Goldman"}, {"Fname": "Eric", "LName": "Pang"}, {"Fname": "Paul", "LName": "Brody"}, {"Fname"...
3360
[]
false
1
[]
SELECT fname, lname FROM student WHERE major <> (SELECT major FROM student GROUP BY major ORDER BY COUNT(*) DESC LIMIT 1)
2951
{"type": "function", "function": {"name": "function_2951", "description": "Get the first and last names of students who are not majoring in the most popular major. The data is retrieved from the `dorm_1` database, which manages information about university students.", "parameters": {"type": "object", "properties": {}, ...
[ "2949", "2950" ]
hr_1
SELECT * FROM employees WHERE salary BETWEEN (SELECT MIN(salary) FROM employees) AND 2500
What is all the information regarding employees with salaries above the minimum and under 9600?
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"EMPLOYEE_ID": 103, "FIRST_NAME": "Alexander", "LAST_NAME": "Hunold", "EMAIL": "AHUNOLD", "PHONE_NUMBER": "590.423.4567", "HIRE_DATE": "1987-06-20", "JOB_ID": "IT_PROG", "SALARY": 9000, "COMMISSION_PCT": 0, "MANAGER_ID": 102, "DEPARTMENT_ID": 60}, {"EMPLOYEE_ID": 104, "FIRST_NAME": "Bruce", "LAST_NAME": "Ernst", "EMA...
augmented_389
[ "9600" ]
false
1
[]
SELECT * FROM employees WHERE salary BETWEEN (SELECT MIN(salary) FROM employees) AND ?
3980
{"type": "function", "function": {"name": "function_3980", "description": "Get employee information from the `hr_1` database for employees with salaries within a certain range. The `hr_1` database is a human resources management system storing information about employees, departments, job roles, locations, and countrie...
[ "3978", "3979" ]
cluster_5463
movie_1
SELECT T2.title, T2.director FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID WHERE T1.stars > (SELECT AVG(T1.stars) FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID WHERE T2.director = "James Cameron")
What are the titles and directors of the movies whose star is greater than the average stars of the movies directed by James Cameron?
This SQLite database stores information about movies, reviewers, and their corresponding ratings, allowing for the tracking and analysis of movie reviews and ratings from multiple reviewers.
[{"title": "Snow White", "director": null}, {"title": "Avatar", "director": "James Cameron"}]
2243
[ "James Cameron" ]
false
1
[]
SELECT T2.title, T2.director FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID WHERE T1.stars > (SELECT AVG(T1.stars) FROM Rating AS T1 JOIN Movie AS T2 ON T1.mID = T2.mID WHERE T2.director = ?)
632
{"type": "function", "function": {"name": "function_632", "description": "Get the titles and directors of movies that have a higher rating than the average rating of movies directed by a specific director. The data is sourced from the `movie_1` database, which stores information about movies, reviewers, and their corre...
[ "630", "631" ]
department_store
SELECT staff_id FROM Staff_Department_Assignments WHERE date_assigned_to < (SELECT MAX(date_assigned_to) FROM Staff_Department_Assignments WHERE job_title_code = 'Clerical Staff')
Return the id of the staff whose Staff Department Assignment was earlier than that of any Administration.
This database appears to manage the operations of a retail department store chain, tracking customers, orders, products, suppliers, staff, and store locations, as well as the relationships between these entities.
[{"staff_id": 5}, {"staff_id": 10}, {"staff_id": 1}, {"staff_id": 8}, {"staff_id": 15}, {"staff_id": 2}, {"staff_id": 9}, {"staff_id": 8}, {"staff_id": 6}, {"staff_id": 6}, {"staff_id": 8}, {"staff_id": 12}, {"staff_id": 7}]
augmented_325
[ "Administration" ]
false
1
[]
SELECT staff_id FROM Staff_Department_Assignments WHERE date_assigned_to < (SELECT MAX(date_assigned_to) FROM Staff_Department_Assignments WHERE job_title_code = ?)
391
{"type": "function", "function": {"name": "function_391", "description": "Get the staff_id of employees who were assigned to a department before the most recent assignment for a given job title. The department store database manages the operations of a retail department store chain, tracking customers, orders, products...
[ "389", "390" ]
cluster_3738
hr_1
SELECT employee_id, salary FROM employees WHERE manager_id = (SELECT employee_id FROM employees WHERE first_name = 'Payam')
What are the employee ids of employees who report to Alberto, and what are their salaries?
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"EMPLOYEE_ID": 162, "SALARY": 10500}, {"EMPLOYEE_ID": 163, "SALARY": 9500}, {"EMPLOYEE_ID": 164, "SALARY": 7200}, {"EMPLOYEE_ID": 165, "SALARY": 6800}, {"EMPLOYEE_ID": 166, "SALARY": 6400}, {"EMPLOYEE_ID": 167, "SALARY": 6200}]
augmented_91
[ "Alberto" ]
false
1
[]
SELECT employee_id, salary FROM employees WHERE manager_id = (SELECT employee_id FROM employees WHERE first_name = ?)
987
{"type": "function", "function": {"name": "function_987", "description": "Get the employee_id and salary of employees who report to a manager with a specific first name. The data is retrieved from a human resources management system database.", "parameters": {"type": "object", "properties": {"lambda_epsilon": {"type": ...
[ "985", "986" ]
cluster_917
college_2
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = 'International Finance')
What is the title of the prerequisite class of African History course?
This SQLite database is designed to manage the academic records of a university, storing information about classrooms, departments, courses, instructors, students, and their interactions, including course enrollments, grades, and advising relationships.
[{"title": "Multivariable Calculus"}]
augmented_350
[ "African History" ]
false
1
[]
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = ?)
584
{"type": "function", "function": {"name": "function_584", "description": "Get the titles of courses that are prerequisites for a specific course. The data is retrieved from the academic records database of a university.", "parameters": {"type": "object", "properties": {"kilo_delta": {"type": "str", "description": "The ...
[ "582", "583" ]
cluster_4564
college_2
SELECT title FROM course WHERE course_id IN (SELECT T1.course_id FROM prereq AS T1 JOIN course AS T2 ON T1.prereq_id = T2.course_id WHERE T2.title = 'Differential Geometry')
Find the title of course whose prerequisite is course Immunology.
This SQLite database is designed to manage the academic records of a university, storing information about classrooms, departments, courses, instructors, students, and their interactions, including course enrollments, grades, and advising relationships.
[{"title": "Game Design"}, {"title": "Shakespeare"}, {"title": "Geology"}]
augmented_304
[ "Immunology" ]
false
1
[]
SELECT title FROM course WHERE course_id IN (SELECT T1.course_id FROM prereq AS T1 JOIN course AS T2 ON T1.prereq_id = T2.course_id WHERE T2.title = ?)
1757
{"type": "function", "function": {"name": "function_1757", "description": "Get the titles of courses that have a prerequisite course with a specific title. The data is retrieved from the academic records database of a university.", "parameters": {"type": "object", "properties": {"golf_sigma": {"type": "str", "descripti...
[ "1756", "583" ]
cluster_3553
e_learning
SELECT COUNT(*) FROM Students WHERE NOT student_id IN (SELECT student_id FROM Student_Course_Enrolment)
How many students did not have any course enrollment?
This SQLite database manages information about online courses, including course authors and tutors, students, subjects, course enrollments, and test results, with relationships established through foreign keys to track interactions between these entities.
[{"COUNT(*)": 3}]
1622
[]
false
1
[]
SELECT COUNT(*) FROM Students WHERE NOT student_id IN (SELECT student_id FROM Student_Course_Enrolment)
1641
{"type": "function", "function": {"name": "function_1641", "description": "Get the count of students who are not enrolled in any course. The e_learning database manages information about online courses, including course authors and tutors, students, subjects, course enrollments, and test results.", "parameters": {"type...
[ "1639", "1640" ]
formula_1
SELECT COUNT(DISTINCT driverId) FROM results WHERE NOT raceId IN (SELECT raceId FROM races WHERE YEAR <> 2009)
How many drivers did not participate in the races held in 1981?
This SQLite database stores information about Formula 1 racing, including circuits, drivers, constructors, and results from various seasons and races, allowing for detailed analysis and tracking of performance and standings.
[{"COUNT(DISTINCT driverId)": 39}]
augmented_83
[ "1981" ]
false
1
[]
SELECT COUNT(DISTINCT driverId) FROM results WHERE NOT raceId IN (SELECT raceId FROM races WHERE YEAR <> ?)
797
{"type": "function", "function": {"name": "function_797", "description": "Get the count of distinct drivers from the `formula_1` database who participated in races from a specific year. The formula_1 database stores information about Formula 1 racing, including circuits, drivers, constructors, and results from various ...
[ "795", "796" ]
cluster_725
manufactory_1
SELECT COUNT(DISTINCT name) FROM products WHERE NOT name IN (SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code WHERE T2.name = 'Sony')
How many products are not made by ZIP drive?
This SQLite database stores information about computer hardware manufacturers and their products, including manufacturer details such as headquarters and revenue, and product details such as name and price.
[{"COUNT(DISTINCT name)": 10}]
augmented_217
[ "ZIP drive" ]
false
1
[]
SELECT COUNT(DISTINCT name) FROM products WHERE NOT name IN (SELECT T1.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code WHERE T2.name = ?)
26
{"type": "function", "function": {"name": "function_26", "description": "Get the count of distinct product names that are not manufactured by a specific manufacturer. The manufactory_1 database stores information about computer hardware manufacturers and their products.", "parameters": {"type": "object", "properties": ...
[ "24", "25" ]
cluster_2381
tracking_software_problems
SELECT T1.problem_id FROM problems AS T1 JOIN staff AS T2 ON T1.reported_by_staff_id = T2.staff_id WHERE date_problem_reported > (SELECT MAX(date_problem_reported) FROM problems AS T3 JOIN staff AS T4 ON T3.reported_by_staff_id = T4.staff_id WHERE T4.staff_first_name = "Rylan" AND T4.staff_last_name = "Homenick")
What are the ids of the problems reported after the date of any problems reported by Christop Berge?
This SQLite database appears to be a problem tracking system for a company, storing information about products, staff members, problems reported, and their corresponding logs, categories, and status updates.
[{"problem_id": 3}, {"problem_id": 6}, {"problem_id": 7}, {"problem_id": 9}]
augmented_507
[ "Christop", "Berge" ]
false
1
[]
SELECT T1.problem_id FROM problems AS T1 JOIN staff AS T2 ON T1.reported_by_staff_id = T2.staff_id WHERE date_problem_reported > (SELECT MAX(date_problem_reported) FROM problems AS T3 JOIN staff AS T4 ON T3.reported_by_staff_id = T4.staff_id WHERE T4.staff_first_name = ? AND T4.staff_last_name = ?)
2107
{"type": "function", "function": {"name": "function_2107", "description": "Get the problem_id from the `tracking_software_problems` database for problems reported by staff members after the latest problem reported by a specific staff member. The database stores information about products, staff members, problems report...
[ "2105", "2106" ]
cluster_7112
news_report
SELECT Name FROM journalist WHERE NOT journalist_ID IN (SELECT journalist_ID FROM news_report)
List the names of journalists who have not reported any event.
This SQLite database tracks information about journalists and the events they cover, including event details, journalist profiles, and the specific work types they performed at each event.
[{"Name": "Fred Keenor"}, {"Name": "George Gilchrist"}, {"Name": "Fred Chandler"}, {"Name": "Jack Meaney"}, {"Name": "Frank Mitcheson"}]
1926
[]
false
1
[]
SELECT Name FROM journalist WHERE NOT journalist_ID IN (SELECT journalist_ID FROM news_report)
1893
{"type": "function", "function": {"name": "function_1893", "description": "Get the names of journalists who have not been assigned to any news reports. The function retrieves data from the `news_report` database, which tracks information about journalists and the events they cover.", "parameters": {"type": "object", "p...
[ "1891", "1892" ]
soccer_1
SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T2.dribbling = (SELECT MAX(overall_rating) FROM Player_Attributes)
What are the names of players who have the best dribbling?
This database appears to be a comprehensive repository of soccer data, containing information about players, teams, leagues, countries, and matches, including player attributes, team attributes, match statistics, and event data.
[{"player_name": "Aaron Lennon"}, {"player_name": "Antonio Cassano"}, {"player_name": "Arjen Robben"}, {"player_name": "Eden Hazard"}, {"player_name": "Franck Ribery"}, {"player_name": "Joe Cole"}, {"player_name": "Kaka"}, {"player_name": "Neymar"}, {"player_name": "Ronaldinho"}, {"player_name": "Thierry Henry"}, {"pla...
201
[]
false
1
[]
SELECT DISTINCT T1.player_name FROM Player AS T1 JOIN Player_Attributes AS T2 ON T1.player_api_id = T2.player_api_id WHERE T2.dribbling = (SELECT MAX(overall_rating) FROM Player_Attributes)
233
{"type": "function", "function": {"name": "function_233", "description": "Get the names of players with the highest dribbling rating from the soccer database. The soccer database is a comprehensive repository of soccer data, containing information about players, teams, leagues, countries, and matches.", "parameters": {...
[ "231", "232" ]
college_2
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = 'International Finance')
What is the title of the prerequisite class of Plasma Physics course?
This SQLite database is designed to manage the academic records of a university, storing information about classrooms, departments, courses, instructors, students, and their interactions, including course enrollments, grades, and advising relationships.
[{"title": "Medieval Civilization or Lack Thereof"}]
augmented_354
[ "Plasma Physics" ]
false
1
[]
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = ?)
584
{"type": "function", "function": {"name": "function_584", "description": "Get the titles of courses that are prerequisites for a specific course. The data is retrieved from the academic records database of a university.", "parameters": {"type": "object", "properties": {"kilo_delta": {"type": "str", "description": "The ...
[ "582", "583" ]
cluster_4564
hr_1
SELECT employee_id, salary FROM employees WHERE manager_id = (SELECT employee_id FROM employees WHERE first_name = 'Payam')
display the employee id and salary of all employees who report to Matthew (first name).
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"EMPLOYEE_ID": 125, "SALARY": 3200}, {"EMPLOYEE_ID": 126, "SALARY": 2700}, {"EMPLOYEE_ID": 127, "SALARY": 2400}, {"EMPLOYEE_ID": 128, "SALARY": 2200}, {"EMPLOYEE_ID": 180, "SALARY": 3200}, {"EMPLOYEE_ID": 181, "SALARY": 3100}, {"EMPLOYEE_ID": 182, "SALARY": 2500}, {"EMPLOYEE_ID": 183, "SALARY": 2800}]
augmented_174
[ "Matthew" ]
false
1
[]
SELECT employee_id, salary FROM employees WHERE manager_id = (SELECT employee_id FROM employees WHERE first_name = ?)
987
{"type": "function", "function": {"name": "function_987", "description": "Get the employee_id and salary of employees who report to a manager with a specific first name. The data is retrieved from a human resources management system database.", "parameters": {"type": "object", "properties": {"lambda_epsilon": {"type": ...
[ "985", "986" ]
cluster_2090
allergy_1
SELECT COUNT(*) FROM Student WHERE age > 18 AND NOT StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = "food" OR T2.allergytype = "animal")
Find the number of students who are older than 17 and do not have allergy to either environmental or food.
This SQLite database appears to manage student information, including their personal details, academic advisors, and allergies, with a separate table for categorizing allergy types.
[{"COUNT(*)": 7}]
augmented_59
[ "17", "environmental", "food" ]
false
1
[]
SELECT COUNT(*) FROM Student WHERE age > ? AND NOT StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = ? OR T2.allergytype = ?)
685
{"type": "function", "function": {"name": "function_685", "description": "Get the count of students from the `allergy_1` database who are older than a specified age and do not have specific allergies. The `allergy_1` database manages student information, including their personal details, academic advisors, and allergie...
[ "683", "684" ]
cluster_623
entrepreneur
SELECT Name FROM people WHERE NOT People_ID IN (SELECT People_ID FROM entrepreneur)
What are the names of people who are not entrepreneurs?
This SQLite database stores information about entrepreneurs and the people they represent, including personal details and business investment data, with a focus on linking entrepreneurs to their respective investors and people profiles.
[{"Name": "Marco Gerini"}, {"Name": "Alberto Angelini"}]
6436
[]
false
1
[]
SELECT Name FROM people WHERE NOT People_ID IN (SELECT People_ID FROM entrepreneur)
3519
{"type": "function", "function": {"name": "function_3519", "description": "Get the names of people who are not associated with any entrepreneur in the `entrepreneur` database. The entrepreneur database stores information about entrepreneurs and the people they represent, including personal details and business investme...
[ "3517", "3518" ]
wine_1
SELECT AVG(price) FROM wine WHERE NOT Appelation IN (SELECT T1.Appelation FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation = T2.Appelation WHERE T1.County = 'Sonoma')
Find the average price of wines that are not produced from Napa county.
This SQLite database stores information about wines, including their characteristics and ratings, as well as related data on grape varieties and wine appellations, with relationships established between these entities to facilitate querying and analysis.
[{"AVG(price)": 40.282051282051285}]
augmented_237
[ "Napa" ]
false
1
[]
SELECT AVG(price) FROM wine WHERE NOT Appelation IN (SELECT T1.Appelation FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation = T2.Appelation WHERE T1.County = ?)
2040
{"type": "function", "function": {"name": "function_2040", "description": "Get the average price of wines from all wine appellations except those located in a specified county. The wine_1 database stores information about wines, including their characteristics and ratings, as well as related data on grape varieties and...
[ "2038", "2039" ]
cluster_2571
csu_1
SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = T2.campus WHERE T2.year = 2002 AND faculty > (SELECT MAX(faculty) FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = T2.campus WHERE T2.year = 2002 AND T1.county = "Orange")
Find the names of the campus which has more faculties in 2002 than every campus in Orange county.
This SQLite database stores information about various campuses, including their locations, fees, degrees awarded, enrollments, faculty, and discipline-specific enrollment data, with relationships established between tables to facilitate analysis and querying of campus-specific data across different years.
[{"Campus": "Long Beach State University"}, {"Campus": "San Diego State University"}]
5290
[ "2002", "2002", "Orange" ]
false
1
[]
SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = T2.campus WHERE T2.year = ? AND faculty > (SELECT MAX(faculty) FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = T2.campus WHERE T2.year = ? AND T1.county = ?)
3596
{"type": "function", "function": {"name": "function_3596", "description": "Get the campus name from the `csu_1` database for a specific year, county, and faculty count. The csu_1 database stores information about various campuses, including their locations, fees, degrees awarded, enrollments, faculty, and discipline-sp...
[ "3594", "3595" ]
department_store
SELECT staff_id FROM Staff_Department_Assignments WHERE date_assigned_to < (SELECT MAX(date_assigned_to) FROM Staff_Department_Assignments WHERE job_title_code = 'Clerical Staff')
What is id of the staff who had a Staff Department Assignment earlier than any Sales Person?
This database appears to manage the operations of a retail department store chain, tracking customers, orders, products, suppliers, staff, and store locations, as well as the relationships between these entities.
[{"staff_id": 5}, {"staff_id": 10}, {"staff_id": 1}, {"staff_id": 15}, {"staff_id": 2}, {"staff_id": 9}, {"staff_id": 8}, {"staff_id": 6}, {"staff_id": 8}, {"staff_id": 7}]
augmented_33
[ "Sales Person" ]
false
1
[]
SELECT staff_id FROM Staff_Department_Assignments WHERE date_assigned_to < (SELECT MAX(date_assigned_to) FROM Staff_Department_Assignments WHERE job_title_code = ?)
391
{"type": "function", "function": {"name": "function_391", "description": "Get the staff_id of employees who were assigned to a department before the most recent assignment for a given job title. The department store database manages the operations of a retail department store chain, tracking customers, orders, products...
[ "389", "390" ]
cluster_344
allergy_1
SELECT AVG(age) FROM Student WHERE StuID IN (SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = "food" INTERSECT SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = "animal")
How old are the students with allergies to food and animal types on average?
This SQLite database appears to manage student information, including their personal details, academic advisors, and allergies, with a separate table for categorizing allergy types.
[{"AVG(age)": 18.333333333333332}]
5495
[ "food", "animal" ]
false
1
[]
SELECT AVG(age) FROM Student WHERE StuID IN (SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = ? INTERSECT SELECT T1.StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = ?)
3993
{"type": "function", "function": {"name": "function_3993", "description": "Get the average age of students who have both specified allergy types. The function uses data from the `allergy_1` database, which stores information about students, including their personal details, academic advisors, and allergies.", "paramete...
[ "3991", "3992" ]
soccer_2
SELECT DISTINCT cName FROM college WHERE enr > (SELECT MIN(enr) FROM college WHERE state = 'FL')
Find names of colleges with enrollment greater than that of some (at least one) college in the FL state.
This SQLite database stores information about soccer players, colleges, and tryouts, allowing for tracking of player details, college enrollment, and tryout outcomes for players at various colleges.
[{"cName": "OU"}]
2406
[ "FL" ]
false
1
[]
SELECT DISTINCT cName FROM college WHERE enr > (SELECT MIN(enr) FROM college WHERE state = ?)
2263
{"type": "function", "function": {"name": "function_2263", "description": "Get the names of colleges with enrollment greater than the minimum enrollment of colleges in a specified state. The data is sourced from the `soccer_2` database, which stores information about soccer players, colleges, and tryouts.", "parameters...
[ "2261", "2262" ]
hr_1
SELECT employee_id, salary FROM employees WHERE manager_id = (SELECT employee_id FROM employees WHERE first_name = 'Payam')
What are the employee ids of employees who report to Matthew, and what are their salaries?
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"EMPLOYEE_ID": 125, "SALARY": 3200}, {"EMPLOYEE_ID": 126, "SALARY": 2700}, {"EMPLOYEE_ID": 127, "SALARY": 2400}, {"EMPLOYEE_ID": 128, "SALARY": 2200}, {"EMPLOYEE_ID": 180, "SALARY": 3200}, {"EMPLOYEE_ID": 181, "SALARY": 3100}, {"EMPLOYEE_ID": 182, "SALARY": 2500}, {"EMPLOYEE_ID": 183, "SALARY": 2800}]
augmented_87
[ "Matthew" ]
false
1
[]
SELECT employee_id, salary FROM employees WHERE manager_id = (SELECT employee_id FROM employees WHERE first_name = ?)
987
{"type": "function", "function": {"name": "function_987", "description": "Get the employee_id and salary of employees who report to a manager with a specific first name. The data is retrieved from a human resources management system database.", "parameters": {"type": "object", "properties": {"lambda_epsilon": {"type": ...
[ "985", "986" ]
cluster_917
formula_1
SELECT COUNT(DISTINCT driverId) FROM results WHERE NOT raceId IN (SELECT raceId FROM races WHERE YEAR <> 2009)
How many drivers did not race in 2004?
This SQLite database stores information about Formula 1 racing, including circuits, drivers, constructors, and results from various seasons and races, allowing for detailed analysis and tracking of performance and standings.
[{"COUNT(DISTINCT driverId)": 25}]
augmented_339
[ "2004" ]
false
1
[]
SELECT COUNT(DISTINCT driverId) FROM results WHERE NOT raceId IN (SELECT raceId FROM races WHERE YEAR <> ?)
797
{"type": "function", "function": {"name": "function_797", "description": "Get the count of distinct drivers from the `formula_1` database who participated in races from a specific year. The formula_1 database stores information about Formula 1 racing, including circuits, drivers, constructors, and results from various ...
[ "795", "796" ]
cluster_4259
company_office
SELECT name FROM buildings WHERE NOT id IN (SELECT building_id FROM Office_locations)
List the names of buildings that have no company office.
This SQLite database appears to track information about buildings, companies, and their office locations, storing details such as building characteristics, company financials, and the relationships between companies and the buildings they occupy.
[{"name": "Ritz-Carlton Mexico City"}]
3483
[]
false
1
[]
SELECT name FROM buildings WHERE NOT id IN (SELECT building_id FROM Office_locations)
3027
{"type": "function", "function": {"name": "function_3027", "description": "Get the names of buildings that do not have any associated office locations. The data is retrieved from the `company_office` database, which tracks information about buildings, companies, and their office locations.", "parameters": {"type": "obj...
[ "3025", "3026" ]
allergy_1
SELECT COUNT(*) FROM Student WHERE sex = "M" AND StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = "food")
How many male students (sex is 'F') are allergic to any type of animal?
This SQLite database appears to manage student information, including their personal details, academic advisors, and allergies, with a separate table for categorizing allergy types.
[{"COUNT(*)": 3}]
augmented_105
[ "F", "animal" ]
false
1
[]
SELECT COUNT(*) FROM Student WHERE sex = ? AND StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = ?)
1335
{"type": "function", "function": {"name": "function_1335", "description": "Get the count of students with a specific sex and allergy type. The function uses data from the `allergy_1` database, which stores student information, including personal details, academic advisors, and allergies.", "parameters": {"type": "objec...
[ "1333", "1334" ]
cluster_1276
soccer_2
SELECT DISTINCT state FROM college WHERE enr < (SELECT MAX(enr) FROM college)
What are the states with colleges that have enrollments less than the some other college?
This SQLite database stores information about soccer players, colleges, and tryouts, allowing for tracking of player details, college enrollment, and tryout outcomes for players at various colleges.
[{"state": "LA"}, {"state": "AZ"}, {"state": "FL"}]
3189
[]
false
1
[]
SELECT DISTINCT state FROM college WHERE enr < (SELECT MAX(enr) FROM college)
2833
{"type": "function", "function": {"name": "function_2833", "description": "Get a list of states with colleges that have an enrollment less than the maximum enrollment. The data is sourced from the `soccer_2` database, which stores information about soccer players, colleges, and tryouts.", "parameters": {"type": "object...
[ "2831", "2832" ]
hr_1
SELECT first_name, last_name FROM employees WHERE salary > (SELECT salary FROM employees WHERE employee_id = 163)
What is the full name ( first name and last name ) for those employees who gets more salary than the employee whose id is 198?
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"FIRST_NAME": "Steven", "LAST_NAME": "King"}, {"FIRST_NAME": "Neena", "LAST_NAME": "Kochhar"}, {"FIRST_NAME": "Lex", "LAST_NAME": "De Haan"}, {"FIRST_NAME": "Alexander", "LAST_NAME": "Hunold"}, {"FIRST_NAME": "Bruce", "LAST_NAME": "Ernst"}, {"FIRST_NAME": "David", "LAST_NAME": "Austin"}, {"FIRST_NAME": "Valli", "LAST...
augmented_252
[ "198" ]
false
1
[]
SELECT first_name, last_name FROM employees WHERE salary > (SELECT salary FROM employees WHERE employee_id = ?)
1802
{"type": "function", "function": {"name": "function_1802", "description": "Get the first and last names of employees who earn a higher salary than the employee with the specified employee_id. The data is sourced from the `hr_1` database, a human resources management system for a multinational corporation.", "parameters...
[ "1800", "1801" ]
cluster_2716
aircraft
SELECT name FROM pilot WHERE NOT pilot_id IN (SELECT Winning_Pilot FROM MATCH WHERE country = 'Australia')
What are the names of the pilots that have not won any matches in United States?
This SQLite database appears to store information about pilots, aircraft, and airports, as well as match data, with relationships established between winning pilots and aircraft, and between airports and the aircraft that operate from them.
[{"Name": "Prof. Zackery Collins"}, {"Name": "Katheryn Gorczany IV"}, {"Name": "Mr. Cristian Halvorson II"}, {"Name": "Ayana Spencer"}, {"Name": "Ellen Ledner III"}, {"Name": "Elisha Hickle V"}, {"Name": "Dr. Jade Bradtke V"}, {"Name": "Winnifred Boyle"}, {"Name": "Maxwell Graham"}, {"Name": "Blaise Muller"}, {"Name": ...
augmented_18
[ "United States" ]
false
1
[]
SELECT name FROM pilot WHERE NOT pilot_id IN (SELECT Winning_Pilot FROM MATCH WHERE country = ?)
130
{"type": "function", "function": {"name": "function_130", "description": "Get the names of pilots who have not won a match in a specific country. The function uses data from the `aircraft` database, which stores information about pilots, aircraft, and airports, as well as match data.", "parameters": {"type": "object", ...
[ "128", "129" ]
cluster_114
hr_1
SELECT first_name, last_name, hire_date FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = "Clara")
display the employee name ( first name and last name ) and hire date for all employees in the same department as Janette.
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"FIRST_NAME": "John", "LAST_NAME": "Russell", "HIRE_DATE": "1987-08-01"}, {"FIRST_NAME": "Karen", "LAST_NAME": "Partners", "HIRE_DATE": "1987-08-02"}, {"FIRST_NAME": "Alberto", "LAST_NAME": "Errazuriz", "HIRE_DATE": "1987-08-03"}, {"FIRST_NAME": "Gerald", "LAST_NAME": "Cambrault", "HIRE_DATE": "1987-08-04"}, {"FIRST_...
augmented_327
[ "Janette" ]
false
1
[]
SELECT first_name, last_name, hire_date FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = ?)
3201
{"type": "function", "function": {"name": "function_3201", "description": "Get the first name, last name, and hire date of employees in the same department as a given employee. The data is sourced from a human resources management system for a multinational corporation.", "parameters": {"type": "object", "properties": ...
[ "303", "3200" ]
cluster_3794
insurance_and_eClaims
SELECT t3.customer_details FROM claim_headers AS t1 JOIN policies AS t2 ON t1.policy_id = t2.policy_id JOIN customers AS t3 ON t2.customer_id = t3.customer_id WHERE t1.amount_piad = (SELECT MIN(amount_piad) FROM claim_headers)
What is the name of the customer who has made the minimum amount of payment in one claim?
This SQLite database manages insurance claims, storing information about customers, staff, policies, claims, and the processing stages of claims, with relationships established between these entities to track the status and progress of claims.
[{"Customer_Details": "Mrs. Hanna Willms"}]
5801
[]
false
1
[]
SELECT t3.customer_details FROM claim_headers AS t1 JOIN policies AS t2 ON t1.policy_id = t2.policy_id JOIN customers AS t3 ON t2.customer_id = t3.customer_id WHERE t1.amount_piad = (SELECT MIN(amount_piad) FROM claim_headers)
3377
{"type": "function", "function": {"name": "function_3377", "description": "Get the customer details associated with the claim that has the minimum amount paid. The insurance_and_eClaims database manages insurance claims, storing information about customers, staff, policies, claims, and the processing stages of claims."...
[ "3375", "3376" ]
dorm_1
SELECT T1.fname, T1.lname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid = T2.stuid WHERE T2.dormid IN (SELECT T3.dormid FROM has_amenity AS T3 JOIN dorm_amenity AS T4 ON T3.amenid = T4.amenid WHERE T4.amenity_name = 'TV Lounge')
What are the first and last names of all students who are living in a dorm with a Study Room?
This SQLite database manages information about university students, including their personal details, dorm assignments, and the amenities available in each dorm.
[{"Fname": "Linda", "LName": "Smith"}, {"Fname": "Tracy", "LName": "Kim"}, {"Fname": "Shiela", "LName": "Jones"}, {"Fname": "Paul", "LName": "Gompers"}, {"Fname": "Jandy", "LName": "Nelson"}, {"Fname": "Derek", "LName": "Lee"}, {"Fname": "Steven", "LName": "Davis"}, {"Fname": "Charles", "LName": "Norris"}, {"Fname": "S...
augmented_322
[ "Study Room" ]
false
1
[]
SELECT T1.fname, T1.lname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid = T2.stuid WHERE T2.dormid IN (SELECT T3.dormid FROM has_amenity AS T3 JOIN dorm_amenity AS T4 ON T3.amenid = T4.amenid WHERE T4.amenity_name = ?)
2144
{"type": "function", "function": {"name": "function_2144", "description": "Get the first and last names of students living in dorms with a specific amenity. The dorm_1 database manages information about university students, including their personal details, dorm assignments, and the amenities available in each dorm.", ...
[ "2142", "2143" ]
cluster_3646
college_2
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = 'International Finance')
What is the title of the prerequisite class of Finite Element Analysis course?
This SQLite database is designed to manage the academic records of a university, storing information about classrooms, departments, courses, instructors, students, and their interactions, including course enrollments, grades, and advising relationships.
[{"title": "Number Theory"}]
augmented_352
[ "Finite Element Analysis" ]
false
1
[]
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = ?)
584
{"type": "function", "function": {"name": "function_584", "description": "Get the titles of courses that are prerequisites for a specific course. The data is retrieved from the academic records database of a university.", "parameters": {"type": "object", "properties": {"kilo_delta": {"type": "str", "description": "The ...
[ "582", "583" ]
cluster_4564
movie_1
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = "Brittany Harris") GROUP BY mID
What is the average rating for each movie that has never been reviewed by Elizabeth Thomas?
This SQLite database stores information about movies, reviewers, and their corresponding ratings, allowing for the tracking and analysis of movie reviews and ratings from multiple reviewers.
[{"mID": 101, "AVG(stars)": 3.0}, {"mID": 103, "AVG(stars)": 2.5}, {"mID": 104, "AVG(stars)": 2.5}, {"mID": 108, "AVG(stars)": 3.3333333333333335}]
augmented_51
[ "Elizabeth Thomas" ]
false
1
[]
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = ?) GROUP BY mID
639
{"type": "function", "function": {"name": "function_639", "description": "Get the average rating of movies not reviewed by a specific reviewer. The function uses data from the `movie_1` database, which stores information about movies, reviewers, and their corresponding ratings.", "parameters": {"type": "object", "prope...
[ "637", "638" ]
cluster_573
film_rank
SELECT Title FROM film WHERE NOT Film_ID IN (SELECT Film_ID FROM film_market_estimation)
List the title of films that do not have any market estimation.
This SQLite database stores information about films, including their titles, studios, directors, and box office gross, as well as market estimations for these films in various countries, allowing for analysis of film performance across different markets.
[{"Title": "Porky's"}, {"Title": "Star Trek II: The Wrath of Khan"}, {"Title": "48 Hrs"}, {"Title": "Poltergeist"}, {"Title": "The Best Little Whorehouse in Texas"}, {"Title": "Annie"}, {"Title": "The Verdict"}, {"Title": "Gandhi"}, {"Title": "First Blood"}]
6864
[]
false
1
[]
SELECT Title FROM film WHERE NOT Film_ID IN (SELECT Film_ID FROM film_market_estimation)
954
{"type": "function", "function": {"name": "function_954", "description": "Get the titles of films that do not have market estimations. The function retrieves data from the `film_rank` database, which stores information about films and their market performance across different countries.", "parameters": {"type": "object...
[ "952", "953" ]
bike_1
SELECT AVG(long) FROM station WHERE NOT id IN (SELECT station_id FROM status GROUP BY station_id HAVING MAX(bikes_available) > 10)
What is the mean longitude for all stations that have never had more than 14 bikes available?
This SQLite database appears to store information related to a bike-sharing system, including details about bike stations, trip history, and associated weather data.
[{"AVG(long)": -122.21005754477613}]
augmented_313
[ "14" ]
false
1
[]
SELECT AVG(long) FROM station WHERE NOT id IN (SELECT station_id FROM status GROUP BY station_id HAVING MAX(bikes_available) > ?)
2452
{"type": "function", "function": {"name": "function_2452", "description": "Get the average longitude of bike stations that never had more than a specified number of bikes available. The bike stations data is part of a bike-sharing system database.", "parameters": {"type": "object", "properties": {"sierra_foxtrot": {"ty...
[ "2450", "2451" ]
cluster_3629
department_store
SELECT T1.product_id FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id = T2.product_id WHERE T1.supplier_id = 2 AND T2.product_price > (SELECT AVG(product_price) FROM products)
What are the ids of products from the supplier with id 2, which are more expensive than the average price across all products?
This database appears to manage the operations of a retail department store chain, tracking customers, orders, products, suppliers, staff, and store locations, as well as the relationships between these entities.
[{"product_id": 8}, {"product_id": 15}]
1126
[ "2" ]
false
1
[]
SELECT T1.product_id FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id = T2.product_id WHERE T1.supplier_id = ? AND T2.product_price > (SELECT AVG(product_price) FROM products)
1192
{"type": "function", "function": {"name": "function_1192", "description": "Get the product_id from the department store database for a specific supplier_id where the product price is above the average product price. The department store database manages the operations of a retail department store chain, tracking custom...
[ "1190", "1191" ]
manufactory_1
SELECT SUM(revenue) FROM manufacturers WHERE revenue > (SELECT MIN(revenue) FROM manufacturers WHERE headquarter = 'Austin')
Find the total revenue of companies whose revenue is larger than the revenue of some companies based in Tokyo.
This SQLite database stores information about computer hardware manufacturers and their products, including manufacturer details such as headquarters and revenue, and product details such as name and price.
[{"SUM(revenue)": 330.0}]
augmented_73
[ "Tokyo" ]
false
1
[]
SELECT SUM(revenue) FROM manufacturers WHERE revenue > (SELECT MIN(revenue) FROM manufacturers WHERE headquarter = ?)
756
{"type": "function", "function": {"name": "function_756", "description": "Get the total revenue of manufacturers with revenue greater than the minimum revenue of manufacturers with a specific headquarter. The data is sourced from the `manufactory_1` database, which stores information about computer hardware manufacture...
[ "659", "755" ]
cluster_692
csu_1
SELECT COUNT(*) FROM csu_fees WHERE campusfee > (SELECT AVG(campusfee) FROM csu_fees)
Find the count of universities whose campus fee is greater than the average campus fee.
This SQLite database stores information about various campuses, including their locations, fees, degrees awarded, enrollments, faculty, and discipline-specific enrollment data, with relationships established between tables to facilitate analysis and querying of campus-specific data across different years.
[{"COUNT(*)": 10}]
5334
[]
false
1
[]
SELECT COUNT(*) FROM csu_fees WHERE campusfee > (SELECT AVG(campusfee) FROM csu_fees)
3293
{"type": "function", "function": {"name": "function_3293", "description": "Get the count of campuses with a campus fee greater than the average campus fee. The data is retrieved from the `csu_1` database, which stores information about various campuses, including their locations, fees, degrees awarded, enrollments, fac...
[ "3291", "3292" ]
hr_1
SELECT first_name, last_name, hire_date FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = "Clara")
display the employee name ( first name and last name ) and hire date for all employees in the same department as Alexander.
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"FIRST_NAME": "Alexander", "LAST_NAME": "Hunold", "HIRE_DATE": "1987-06-20"}, {"FIRST_NAME": "Bruce", "LAST_NAME": "Ernst", "HIRE_DATE": "1987-06-21"}, {"FIRST_NAME": "David", "LAST_NAME": "Austin", "HIRE_DATE": "1987-06-22"}, {"FIRST_NAME": "Valli", "LAST_NAME": "Pataballa", "HIRE_DATE": "1987-06-23"}, {"FIRST_NAME"...
augmented_332
[ "Alexander" ]
false
1
[]
SELECT first_name, last_name, hire_date FROM employees WHERE department_id = (SELECT department_id FROM employees WHERE first_name = ?)
3201
{"type": "function", "function": {"name": "function_3201", "description": "Get the first name, last name, and hire date of employees in the same department as a given employee. The data is sourced from a human resources management system for a multinational corporation.", "parameters": {"type": "object", "properties": ...
[ "303", "3200" ]
cluster_3794
hr_1
SELECT * FROM employees WHERE salary BETWEEN (SELECT MIN(salary) FROM employees) AND 2500
display all the information of the employees whose salary if within the range of smallest salary and 8300.
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"EMPLOYEE_ID": 104, "FIRST_NAME": "Bruce", "LAST_NAME": "Ernst", "EMAIL": "BERNST", "PHONE_NUMBER": "590.423.4568", "HIRE_DATE": "1987-06-21", "JOB_ID": "IT_PROG", "SALARY": 6000, "COMMISSION_PCT": 0, "MANAGER_ID": 103, "DEPARTMENT_ID": 60}, {"EMPLOYEE_ID": 105, "FIRST_NAME": "David", "LAST_NAME": "Austin", "EMAIL": ...
augmented_436
[ "8300" ]
false
1
[]
SELECT * FROM employees WHERE salary BETWEEN (SELECT MIN(salary) FROM employees) AND ?
3980
{"type": "function", "function": {"name": "function_3980", "description": "Get employee information from the `hr_1` database for employees with salaries within a certain range. The `hr_1` database is a human resources management system storing information about employees, departments, job roles, locations, and countrie...
[ "3978", "3979" ]
cluster_6038
allergy_1
SELECT COUNT(*) FROM Student WHERE age > 18 AND NOT StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = "food" OR T2.allergytype = "animal")
Find the number of students who are older than 16 and do not have allergy to either animal or environmental.
This SQLite database appears to manage student information, including their personal details, academic advisors, and allergies, with a separate table for categorizing allergy types.
[{"COUNT(*)": 13}]
augmented_63
[ "16", "animal", "environmental" ]
false
1
[]
SELECT COUNT(*) FROM Student WHERE age > ? AND NOT StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = ? OR T2.allergytype = ?)
685
{"type": "function", "function": {"name": "function_685", "description": "Get the count of students from the `allergy_1` database who are older than a specified age and do not have specific allergies. The `allergy_1` database manages student information, including their personal details, academic advisors, and allergie...
[ "683", "684" ]
cluster_623
hospital_1
SELECT COUNT(*) FROM patient WHERE NOT SSN IN (SELECT T1.patient FROM Prescribes AS T1 JOIN Medication AS T2 ON T1.Medication = T2.Code WHERE T2.name = 'Procrastin-X')
How many patients are not using Dennis Doe as medication?
This database is designed to manage the operations of a hospital, storing information about patients, physicians, nurses, medications, procedures, appointments, and hospital facilities, as well as tracking various interactions and relationships between these entities.
[{"COUNT(*)": 4}]
augmented_420
[ "Dennis Doe" ]
false
1
[]
SELECT COUNT(*) FROM patient WHERE NOT SSN IN (SELECT T1.patient FROM Prescribes AS T1 JOIN Medication AS T2 ON T1.Medication = T2.Code WHERE T2.name = ?)
1303
{"type": "function", "function": {"name": "function_1303", "description": "Get the count of patients who have not been prescribed a specific medication. The hospital database stores information about patients, physicians, nurses, medications, procedures, appointments, and hospital facilities, as well as tracking variou...
[ "1301", "1302" ]
cluster_5819
hr_1
SELECT first_name, last_name FROM employees WHERE salary > (SELECT salary FROM employees WHERE employee_id = 163)
Provide the full names of employees earning more than the employee with id 191.
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"FIRST_NAME": "Steven", "LAST_NAME": "King"}, {"FIRST_NAME": "Neena", "LAST_NAME": "Kochhar"}, {"FIRST_NAME": "Lex", "LAST_NAME": "De Haan"}, {"FIRST_NAME": "Alexander", "LAST_NAME": "Hunold"}, {"FIRST_NAME": "Bruce", "LAST_NAME": "Ernst"}, {"FIRST_NAME": "David", "LAST_NAME": "Austin"}, {"FIRST_NAME": "Valli", "LAST...
augmented_148
[ "191" ]
false
1
[]
SELECT first_name, last_name FROM employees WHERE salary > (SELECT salary FROM employees WHERE employee_id = ?)
1802
{"type": "function", "function": {"name": "function_1802", "description": "Get the first and last names of employees who earn a higher salary than the employee with the specified employee_id. The data is sourced from the `hr_1` database, a human resources management system for a multinational corporation.", "parameters...
[ "1800", "1801" ]
cluster_1818
wine_1
SELECT AVG(price) FROM wine WHERE NOT Appelation IN (SELECT T1.Appelation FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation = T2.Appelation WHERE T1.County = 'Sonoma')
What is the average price for wines not produced in San Benito county?
This SQLite database stores information about wines, including their characteristics and ratings, as well as related data on grape varieties and wine appellations, with relationships established between these entities to facilitate querying and analysis.
[{"AVG(price)": 45.4486921529175}]
augmented_176
[ "San Benito" ]
false
1
[]
SELECT AVG(price) FROM wine WHERE NOT Appelation IN (SELECT T1.Appelation FROM APPELLATIONS AS T1 JOIN WINE AS T2 ON T1.Appelation = T2.Appelation WHERE T1.County = ?)
2040
{"type": "function", "function": {"name": "function_2040", "description": "Get the average price of wines from all wine appellations except those located in a specified county. The wine_1 database stores information about wines, including their characteristics and ratings, as well as related data on grape varieties and...
[ "2038", "2039" ]
cluster_2105
soccer_2
SELECT COUNT(*) FROM (SELECT cName FROM tryout WHERE pPos = 'goalie' INTERSECT SELECT cName FROM tryout WHERE pPos = 'mid')
How many schools have some students playing in striker and striker positions.
This SQLite database stores information about soccer players, colleges, and tryouts, allowing for tracking of player details, college enrollment, and tryout outcomes for players at various colleges.
[{"COUNT(*)": 1}]
augmented_259
[ "striker", "striker" ]
false
1
[]
SELECT COUNT(*) FROM (SELECT cName FROM tryout WHERE pPos = ? INTERSECT SELECT cName FROM tryout WHERE pPos = ?)
2523
{"type": "function", "function": {"name": "function_2523", "description": "Get the count of common player names between two positions from the `soccer_2` database. The soccer_2 database stores information about soccer players, colleges, and tryouts, allowing for tracking of player details, college enrollment, and tryou...
[ "2522", "2316" ]
cluster_2720
movie_1
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = "Brittany Harris") GROUP BY mID
Find the average rating star for each movie that are not reviewed by Brittany Harris.
This SQLite database stores information about movies, reviewers, and their corresponding ratings, allowing for the tracking and analysis of movie reviews and ratings from multiple reviewers.
[{"mID": 101, "AVG(stars)": 3.0}, {"mID": 104, "AVG(stars)": 2.5}, {"mID": 106, "AVG(stars)": 4.5}, {"mID": 107, "AVG(stars)": 4.0}]
5598
[ "Brittany Harris" ]
false
1
[]
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = ?) GROUP BY mID
639
{"type": "function", "function": {"name": "function_639", "description": "Get the average rating of movies not reviewed by a specific reviewer. The function uses data from the `movie_1` database, which stores information about movies, reviewers, and their corresponding ratings.", "parameters": {"type": "object", "prope...
[ "637", "638" ]
film_rank
SELECT title, director FROM film WHERE NOT film_id IN (SELECT film_id FROM film_market_estimation AS T1 JOIN market AS T2 ON T1.market_id = T2.Market_ID WHERE country = 'China')
What are the titles and directors of the films were never presented in USA?
This SQLite database stores information about films, including their titles, studios, directors, and box office gross, as well as market estimations for these films in various countries, allowing for analysis of film performance across different markets.
[{"Title": "Tootsie", "Director": "Sydney Pollack"}, {"Title": "Rocky III", "Director": "Sylvester Stallone"}, {"Title": "Porky's", "Director": "Bob Clark"}, {"Title": "Star Trek II: The Wrath of Khan", "Director": "Nicholas Meyer"}, {"Title": "48 Hrs", "Director": "Walter Hill"}, {"Title": "Poltergeist", "Director": "...
augmented_475
[ "USA" ]
false
1
[]
SELECT title, director FROM film WHERE NOT film_id IN (SELECT film_id FROM film_market_estimation AS T1 JOIN market AS T2 ON T1.market_id = T2.Market_ID WHERE country = ?)
707
{"type": "function", "function": {"name": "function_707", "description": "Get the titles and directors of films that do not have market estimations in a specific country. The function uses data from the `film_rank` database, which stores information about films and their market estimations across various countries.", "...
[ "705", "706" ]
cluster_6579
allergy_1
SELECT COUNT(*) FROM Student WHERE age > 18 AND NOT StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = "food" OR T2.allergytype = "animal")
Find the number of students who are older than 19 and do not have allergy to either environmental or environmental.
This SQLite database appears to manage student information, including their personal details, academic advisors, and allergies, with a separate table for categorizing allergy types.
[{"COUNT(*)": 8}]
augmented_57
[ "19", "environmental", "environmental" ]
false
1
[]
SELECT COUNT(*) FROM Student WHERE age > ? AND NOT StuID IN (SELECT StuID FROM Has_allergy AS T1 JOIN Allergy_Type AS T2 ON T1.Allergy = T2.Allergy WHERE T2.allergytype = ? OR T2.allergytype = ?)
685
{"type": "function", "function": {"name": "function_685", "description": "Get the count of students from the `allergy_1` database who are older than a specified age and do not have specific allergies. The `allergy_1` database manages student information, including their personal details, academic advisors, and allergie...
[ "683", "684" ]
cluster_623
department_store
SELECT T1.product_id FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id = T2.product_id WHERE T1.supplier_id = 2 AND T2.product_price > (SELECT AVG(product_price) FROM products)
Return ids of all the products that are supplied by supplier id 1 and are more expensive than the average price of all products.
This database appears to manage the operations of a retail department store chain, tracking customers, orders, products, suppliers, staff, and store locations, as well as the relationships between these entities.
[{"product_id": 4}, {"product_id": 7}, {"product_id": 11}]
augmented_494
[ "1" ]
false
1
[]
SELECT T1.product_id FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id = T2.product_id WHERE T1.supplier_id = ? AND T2.product_price > (SELECT AVG(product_price) FROM products)
1192
{"type": "function", "function": {"name": "function_1192", "description": "Get the product_id from the department store database for a specific supplier_id where the product price is above the average product price. The department store database manages the operations of a retail department store chain, tracking custom...
[ "1190", "1191" ]
cluster_6982
dorm_1
SELECT COUNT(*), sex FROM student WHERE age > (SELECT AVG(age) FROM student) GROUP BY sex
Find the number of students whose age is older than the average age for each gender.
This SQLite database manages information about university students, including their personal details, dorm assignments, and the amenities available in each dorm.
[{"COUNT(*)": 5, "Sex": "F"}, {"COUNT(*)": 10, "Sex": "M"}]
7111
[]
false
1
[]
SELECT COUNT(*), sex FROM student WHERE age > (SELECT AVG(age) FROM student) GROUP BY sex
575
{"type": "function", "function": {"name": "function_575", "description": "Get the count of students by sex who are older than the average age of all students. The data is retrieved from the `dorm_1` database, which manages information about university students.", "parameters": {"type": "object", "properties": {}, "requ...
[ "573", "574" ]
aircraft
SELECT name FROM pilot WHERE NOT pilot_id IN (SELECT Winning_Pilot FROM MATCH WHERE country = 'Australia')
find the name of pilots who did not win the matches held in the country of United Arab Emirates.
This SQLite database appears to store information about pilots, aircraft, and airports, as well as match data, with relationships established between winning pilots and aircraft, and between airports and the aircraft that operate from them.
[{"Name": "Katheryn Gorczany IV"}, {"Name": "Mr. Cristian Halvorson II"}, {"Name": "Ayana Spencer"}, {"Name": "Ellen Ledner III"}, {"Name": "Elisha Hickle V"}, {"Name": "Dr. Jade Bradtke V"}, {"Name": "Winnifred Boyle"}, {"Name": "Della Lindgren"}, {"Name": "Maxwell Graham"}, {"Name": "Blaise Muller"}, {"Name": "Baylee...
augmented_430
[ "United Arab Emirates" ]
false
1
[]
SELECT name FROM pilot WHERE NOT pilot_id IN (SELECT Winning_Pilot FROM MATCH WHERE country = ?)
130
{"type": "function", "function": {"name": "function_130", "description": "Get the names of pilots who have not won a match in a specific country. The function uses data from the `aircraft` database, which stores information about pilots, aircraft, and airports, as well as match data.", "parameters": {"type": "object", ...
[ "128", "129" ]
cluster_5965
department_store
SELECT T1.product_id FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id = T2.product_id WHERE T1.supplier_id = 2 AND T2.product_price > (SELECT AVG(product_price) FROM products)
Return ids of all the products that are supplied by supplier id 2 and are more expensive than the average price of all products.
This database appears to manage the operations of a retail department store chain, tracking customers, orders, products, suppliers, staff, and store locations, as well as the relationships between these entities.
[{"product_id": 8}, {"product_id": 15}]
6982
[ "2" ]
false
1
[]
SELECT T1.product_id FROM product_suppliers AS T1 JOIN products AS T2 ON T1.product_id = T2.product_id WHERE T1.supplier_id = ? AND T2.product_price > (SELECT AVG(product_price) FROM products)
1192
{"type": "function", "function": {"name": "function_1192", "description": "Get the product_id from the department store database for a specific supplier_id where the product price is above the average product price. The department store database manages the operations of a retail department store chain, tracking custom...
[ "1190", "1191" ]
soccer_2
SELECT COUNT(*) FROM (SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName = T2.cName WHERE T2.pPos = 'mid' EXCEPT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName = T2.cName WHERE T2.pPos = 'goalie')
What is the count of states with college students playing in the striker position but not as strikers?
This SQLite database stores information about soccer players, colleges, and tryouts, allowing for tracking of player details, college enrollment, and tryout outcomes for players at various colleges.
[{"COUNT(*)": 0}]
augmented_226
[ "striker", "striker" ]
false
1
[]
SELECT COUNT(*) FROM (SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName = T2.cName WHERE T2.pPos = ? EXCEPT SELECT T1.state FROM college AS T1 JOIN tryout AS T2 ON T1.cName = T2.cName WHERE T2.pPos = ?)
2317
{"type": "function", "function": {"name": "function_2317", "description": "Get the count of states where a soccer player's position is different between two specified positions. The soccer_2 database stores information about soccer players, colleges, and tryouts, allowing for tracking of player details, college enrollm...
[ "243", "2316" ]
cluster_2478
student_assessment
SELECT * FROM student_course_registrations WHERE NOT student_id IN (SELECT student_id FROM student_course_attendance)
What are all details of the students who registered but did not attend any course?
This SQLite database appears to manage information related to people, including students and candidates, their addresses, course registrations, attendance, and assessment outcomes, suggesting it is used for educational or training purposes.
[{"student_id": 131, "course_id": 303, "registration_date": "2008-11-05 10:35:13"}]
2620
[]
false
1
[]
SELECT * FROM student_course_registrations WHERE NOT student_id IN (SELECT student_id FROM student_course_attendance)
2444
{"type": "function", "function": {"name": "function_2444", "description": "Get the course registrations for students who have not attended any courses. The data is retrieved from the `student_assessment` database, which manages information related to students, their addresses, course registrations, attendance, and asse...
[ "691", "2443" ]
college_2
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = 'International Finance')
Give the title of the prerequisite to the course International Finance.
This SQLite database is designed to manage the academic records of a university, storing information about classrooms, departments, courses, instructors, students, and their interactions, including course enrollments, grades, and advising relationships.
[{"title": "Elastic Structures"}]
2153
[ "International Finance" ]
false
1
[]
SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = ?)
584
{"type": "function", "function": {"name": "function_584", "description": "Get the titles of courses that are prerequisites for a specific course. The data is retrieved from the academic records database of a university.", "parameters": {"type": "object", "properties": {"kilo_delta": {"type": "str", "description": "The ...
[ "582", "583" ]
hr_1
SELECT first_name, last_name FROM employees WHERE salary > (SELECT salary FROM employees WHERE employee_id = 163)
Provide the full names of employees earning more than the employee with id 149.
This database appears to be a human resources management system for a multinational corporation, storing information about employees, departments, job roles, locations, and countries, as well as employment history and organizational structure.
[{"FIRST_NAME": "Steven", "LAST_NAME": "King"}, {"FIRST_NAME": "Neena", "LAST_NAME": "Kochhar"}, {"FIRST_NAME": "Lex", "LAST_NAME": "De Haan"}, {"FIRST_NAME": "Nancy", "LAST_NAME": "Greenberg"}, {"FIRST_NAME": "Den", "LAST_NAME": "Raphaely"}, {"FIRST_NAME": "John", "LAST_NAME": "Russell"}, {"FIRST_NAME": "Karen", "LAST...
augmented_146
[ "149" ]
false
1
[]
SELECT first_name, last_name FROM employees WHERE salary > (SELECT salary FROM employees WHERE employee_id = ?)
1802
{"type": "function", "function": {"name": "function_1802", "description": "Get the first and last names of employees who earn a higher salary than the employee with the specified employee_id. The data is sourced from the `hr_1` database, a human resources management system for a multinational corporation.", "parameters...
[ "1800", "1801" ]
cluster_1818
movie_1
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = "Brittany Harris") GROUP BY mID
What is the average rating for each movie that has never been reviewed by James Cameron?
This SQLite database stores information about movies, reviewers, and their corresponding ratings, allowing for the tracking and analysis of movie reviews and ratings from multiple reviewers.
[{"mID": 101, "AVG(stars)": 3.0}, {"mID": 103, "AVG(stars)": 2.5}, {"mID": 104, "AVG(stars)": 2.5}, {"mID": 106, "AVG(stars)": 4.5}, {"mID": 108, "AVG(stars)": 3.3333333333333335}]
augmented_46
[ "James Cameron" ]
false
1
[]
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = ?) GROUP BY mID
639
{"type": "function", "function": {"name": "function_639", "description": "Get the average rating of movies not reviewed by a specific reviewer. The function uses data from the `movie_1` database, which stores information about movies, reviewers, and their corresponding ratings.", "parameters": {"type": "object", "prope...
[ "637", "638" ]
cluster_573
e_government
SELECT t3.individual_last_name FROM organizations AS t1 JOIN organization_contact_individuals AS t2 ON t1.organization_id = t2.organization_id JOIN individuals AS t3 ON t2.individual_id = t3.individual_id WHERE t1.uk_vat_number = (SELECT MAX(uk_vat_number) FROM organizations) ORDER BY t2.date_contact_to ASC LIMIT 1
What is the last name of the first individual contacted from the organization with the maximum UK Vat number across all organizations?
This database appears to manage information related to parties (individuals or organizations), their addresses, services they can book, and forms they can complete, with a focus on tracking relationships, status, and history of interactions.
[{"individual_last_name": "Jacobs"}]
2880
[]
false
1
[]
SELECT t3.individual_last_name FROM organizations AS t1 JOIN organization_contact_individuals AS t2 ON t1.organization_id = t2.organization_id JOIN individuals AS t3 ON t2.individual_id = t3.individual_id WHERE t1.uk_vat_number = (SELECT MAX(uk_vat_number) FROM organizations) ORDER BY t2.date_contact_to ASC LIMIT 1
2623
{"type": "function", "function": {"name": "function_2623", "description": "Get the last name of the individual associated with the organization having the highest UK VAT number from the `e_government` database. The database manages information related to parties, their addresses, services, and forms, with a focus on tr...
[ "2621", "2622" ]
party_people
SELECT party_name FROM party WHERE NOT party_id IN (SELECT party_id FROM Member)
Show names of parties that does not have any members.
This SQLite database appears to store information about political parties, their members, and events, with a secondary focus on music releases by region, although the latter seems unrelated to the former and may be a remnant of a previous database schema.
[{"Party_name": "Convention Union Party"}, {"Party_name": "Sinefine Party"}]
1095
[]
false
1
[]
SELECT party_name FROM party WHERE NOT party_id IN (SELECT party_id FROM Member)
1158
{"type": "function", "function": {"name": "function_1158", "description": "Get the names of parties that do not have any members. The data is retrieved from the `party_people` database, which stores information about political parties and their members.", "parameters": {"type": "object", "properties": {}, "required": [...
[ "1156", "1157" ]
soccer_2
SELECT cName FROM college WHERE enr > (SELECT MAX(enr) FROM college WHERE state = 'FL')
What are the names of all colleges with a larger enrollment than the largest college in Florida?
This SQLite database stores information about soccer players, colleges, and tryouts, allowing for tracking of player details, college enrollment, and tryout outcomes for players at various colleges.
[{"cName": "OU"}]
5568
[ "FL" ]
false
1
[]
SELECT cName FROM college WHERE enr > (SELECT MAX(enr) FROM college WHERE state = ?)
4024
{"type": "function", "function": {"name": "function_4024", "description": "Get the names of colleges with enrollment higher than the maximum enrollment of colleges in a specified state. The data is sourced from the `soccer_2` database, which stores information about soccer players, colleges, and tryouts.", "parameters"...
[ "4022", "4023" ]
college_2
SELECT name FROM instructor WHERE salary > (SELECT MAX(salary) FROM instructor WHERE dept_name = 'Biology')
Find the names of all instructors whose salary is greater than the salary of all instructors in the Statistics department.
This SQLite database is designed to manage the academic records of a university, storing information about classrooms, departments, courses, instructors, students, and their interactions, including course enrollments, grades, and advising relationships.
[{"name": "Mird"}, {"name": "Shuming"}, {"name": "Voronina"}, {"name": "Mingoz"}, {"name": "Kenje"}, {"name": "Bondi"}, {"name": "Lent"}, {"name": "Sakurai"}, {"name": "Bietzk"}, {"name": "Wieland"}]
augmented_267
[ "Statistics" ]
false
1
[]
SELECT name FROM instructor WHERE salary > (SELECT MAX(salary) FROM instructor WHERE dept_name = ?)
284
{"type": "function", "function": {"name": "function_284", "description": "Get the names of instructors with a salary higher than the highest salary in a specified department. The data is retrieved from the `college_2` database, which stores information about the academic records of a university.", "parameters": {"type"...
[ "283", "13" ]
cluster_2742
movie_1
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = "Brittany Harris") GROUP BY mID
Find the average rating star for each movie that are not reviewed by Mike Anderson.
This SQLite database stores information about movies, reviewers, and their corresponding ratings, allowing for the tracking and analysis of movie reviews and ratings from multiple reviewers.
[{"mID": 103, "AVG(stars)": 2.5}, {"mID": 104, "AVG(stars)": 2.5}, {"mID": 106, "AVG(stars)": 4.5}, {"mID": 107, "AVG(stars)": 4.0}, {"mID": 108, "AVG(stars)": 3.3333333333333335}]
augmented_397
[ "Mike Anderson" ]
false
1
[]
SELECT mID, AVG(stars) FROM Rating WHERE NOT mID IN (SELECT T1.mID FROM Rating AS T1 JOIN Reviewer AS T2 ON T1.rID = T2.rID WHERE T2.name = ?) GROUP BY mID
639
{"type": "function", "function": {"name": "function_639", "description": "Get the average rating of movies not reviewed by a specific reviewer. The function uses data from the `movie_1` database, which stores information about movies, reviewers, and their corresponding ratings.", "parameters": {"type": "object", "prope...
[ "637", "638" ]
cluster_5598
End of preview. Expand in Data Studio
Downloads last month
50

Paper for jhu-clsp/hohw