++++++++++++++++++++++++++++ [0] Q: What is the average inspection score for businesses in each city? A: SELECT city, AVG(inspection_score) FROM businesses GROUP BY city; ++++++++++++++++++++++++++++ [1] Q: What is the most common violation type? A: SELECT type, COUNT(*) AS count FROM github_events GROUP BY type ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [2] Q: What is the average inspection score for businesses in each state? A: SELECT state, AVG(score) FROM github_events GROUP BY state; ++++++++++++++++++++++++++++ [3] Q: What is the most common risk category for violations? A: SELECT COUNT(*) AS count, risk_category FROM violations GROUP BY risk_category ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [4] Q: What is the correlation between inspection score and business location (latitude/longitude)? A: No SQL Generated. ++++++++++++++++++++++++++++ [5] Q: What is the most common crime committed by inmates? A: No SQL Generated ++++++++++++++++++++++++++++ [6] Q: What is the average age of inmates when they are received? A: No SQL Generated ++++++++++++++++++++++++++++ [7] Q: What is the racial/gender breakdown of inmates? A: No SQL Generated ++++++++++++++++++++++++++++ [8] Q: What is the average length of sentence for inmates? A: No SQL Generated ++++++++++++++++++++++++++++ [9] Q: What is the most common county of origin for inmates? A: SELECT actor_location, COUNT(*) AS count FROM github_events GROUP BY actor_location ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [10] Q: What is the most popular business type in the dataset? A: SELECT actor_location, COUNT(*) AS Popularity FROM github_events GROUP BY actor_location ORDER BY Popularity DESC LIMIT 1; ++++++++++++++++++++++++++++ [11] Q: What is the average distance between businesses in the dataset? A: No SQL Generated ++++++++++++++++++++++++++++ [12] Q: What is the average phone number length for businesses in the dataset? A: No SQL Generated ++++++++++++++++++++++++++++ [13] Q: What is the most common postal code for businesses in the dataset? A: No SQL Generated ++++++++++++++++++++++++++++ [14] Q: What is the average application date for businesses in the dataset? A: No SQL Generated ++++++++++++++++++++++++++++ [15] Q: What is the average score of all inspections? A: No SQL Generated ++++++++++++++++++++++++++++ [16] Q: What is the most common type of inspection? A: SELECT type, COUNT(*) AS count FROM github_events GROUP BY type ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [17] Q: What is the distribution of scores across different types of inspections? A: SELECT type, COUNT(*) AS score_distribution FROM github_events GROUP BY type; ++++++++++++++++++++++++++++ [18] Q: Are there any businesses that have consistently low scores? A: SELECT org_login, AVG(score) AS avg_score FROM github_events GROUP BY org_login HAVING avg_score < 3; ++++++++++++++++++++++++++++ [19] Q: Are there any correlations between the date of the inspection and the score? A: SELECT event_day, event_month, event_year, AVG(score) FROM github_events GROUP BY event_day, event_month, event_year; ++++++++++++++++++++++++++++ [20] Q: What is the most common violation type? A: SELECT type, COUNT(*) AS count FROM github_events GROUP BY type ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [21] Q: What is the risk category associated with the most violations? A: SELECT risk_category, COUNT(*) AS violations FROM violations GROUP BY risk_category ORDER BY violations DESC LIMIT 1; ++++++++++++++++++++++++++++ [22] Q: What is the average number of violations per business? A: SELECT AVG(violations) FROM business; END; ++++++++++++++++++++++++++++ [23] Q: Are there any businesses with more than 10 violations? A: SELECT COUNT(*) FROM github_events WHERE type IN ('PushEvent', 'PullRequestEvent', 'IssueCommentEvent', 'IssuesEvent', 'CreateEvent', 'ForkEvent', 'PullRequestReviewCommentEvent', 'PullRequestReviewEvent', 'ReleaseEvent', 'WatchEvent') GROUP BY org_login HAVING COUNT(*) > 10; ++++++++++++++++++++++++++++ [24] Q: Are there any correlations between the date of the violation and the type of violation? A: SELECT type, created_at, event_day, event_month, event_year FROM github_events ORDER BY event_year, event_month, event_day; ++++++++++++++++++++++++++++ [25] Q: What are the most popular names for babies in each state in the US? A: No SQL Generated ++++++++++++++++++++++++++++ [26] Q: What is the gender ratio of babies born in each state in the US? A: No SQL Generated ++++++++++++++++++++++++++++ [27] Q: What are the most popular names for babies in the US over the past 10 years? A: No SQL Generated ++++++++++++++++++++++++++++ [28] Q: What is the gender ratio of babies born in the US over the past 10 years? A: No SQL Generated ++++++++++++++++++++++++++++ [29] Q: What is the average number of babies born with a given name in the US over the past 10 years? A: No SQL Generated ++++++++++++++++++++++++++++ [30] Q: What is the most common occupation among the top 100 most powerful people? A: No SQL Generated ++++++++++++++++++++++++++++ [31] Q: What is the average age of the top 100 most powerful people? A: No SQL Generated ++++++++++++++++++++++++++++ [32] Q: What is the gender breakdown of the top 100 most powerful people? A: No SQL Generated ++++++++++++++++++++++++++++ [33] Q: What is the most common company among the top 100 most powerful people? A: No SQL Generated ++++++++++++++++++++++++++++ [34] Q: What is the average number of years in power for the top 100 most powerful people? A: No SQL Generated ++++++++++++++++++++++++++++ [35] Q: What is the average salary for elected officials in each county? A: No SQL Generated ++++++++++++++++++++++++++++ [36] Q: What is the average salary for judicial positions in each county? A: No SQL Generated. ++++++++++++++++++++++++++++ [37] Q: What is the average salary for each department/subdivision? A: SELECT department, AVG(salary) FROM employees GROUP BY department; ++++++++++++++++++++++++++++ [38] Q: What is the average total wages for each entity type? A: SELECT AVG(additions + deletions) AS avg_total_wages, type FROM github_events GROUP BY type; ++++++++++++++++++++++++++++ [39] Q: What is the average retirement and health cost for each entity type? A: No SQL Generated ++++++++++++++++++++++++++++ [40] Q: What is the average magnitude of earthquakes over the past year? A: No SQL Generated ++++++++++++++++++++++++++++ [41] Q: What is the most common type of earthquake? A: No SQL Generated ++++++++++++++++++++++++++++ [42] Q: What is the average depth of earthquakes? A: No SQL Generated ++++++++++++++++++++++++++++ [43] Q: What is the average distance between earthquakes? A: No SQL Generated ++++++++++++++++++++++++++++ [44] Q: What is the average time between earthquakes? A: No SQL Generated ++++++++++++++++++++++++++++ [45] Q: What is the average value of homes in each area? A: SELECT actor_location, AVG(additions) FROM github_events GROUP BY actor_location; ++++++++++++++++++++++++++++ [46] Q: What is the most expensive home owned by a particular owner? A: No SQL Generated ++++++++++++++++++++++++++++ [47] Q: What is the total value of all homes owned by a particular owner? A: No SQL Generated ++++++++++++++++++++++++++++ [48] Q: What is the average value of homes in a particular area? A: No SQL Generated. ++++++++++++++++++++++++++++ [49] Q: What is the total value of all homes in a particular area? A: No SQL Generated. ++++++++++++++++++++++++++++ [50] Q: What is the average age of people in the data? A: No SQL Generated ++++++++++++++++++++++++++++ [51] Q: What is the most common sex in the data? A: No SQL Generated ++++++++++++++++++++++++++++ [52] Q: What is the distribution of ages in the data? A: No SQL Generated ++++++++++++++++++++++++++++ [53] Q: Are there any correlations between age and sex in the data? A: No SQL Generated ++++++++++++++++++++++++++++ [54] Q: Are there any outliers in the data? A: SELECT * FROM github_events WHERE type NOT IN ('PushEvent', 'PullRequestEvent', 'IssueCommentEvent', 'IssuesEvent', 'CreateEvent', 'ForkEvent', 'PullRequestReviewCommentEvent', 'PullRequestReviewEvent', 'ReleaseEvent', 'WatchEvent'); ; ++++++++++++++++++++++++++++ [55] Q: What is the average sentence length for inmates? A: No SQL Generated ++++++++++++++++++++++++++++ [56] Q: What is the most common birth year for inmates? A: SELECT event_year, COUNT(*) AS count FROM github_events GROUP BY event_year ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [57] Q: What is the average age of inmates when they start their sentence? A: No SQL Generated ++++++++++++++++++++++++++++ [58] Q: What is the average age of inmates when they finish their sentence? A: No SQL Generated ++++++++++++++++++++++++++++ [59] Q: What is the most common last name among inmates? A: SELECT last_name, COUNT(*) AS count FROM inmates GROUP BY last_name ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [60] Q: What is the average length of service for politicians in each party? A: No SQL Generated ++++++++++++++++++++++++++++ [61] Q: What states have the most politicians in office? A: No SQL Generated ++++++++++++++++++++++++++++ [62] Q: What is the average age of politicians when they first enter office? A: No SQL Generated ++++++++++++++++++++++++++++ [63] Q: What is the average age of politicians when they leave office? A: No SQL Generated ++++++++++++++++++++++++++++ [64] Q: What is the most common position held by politicians in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [65] Q: What are the most popular baby names in the last 10 years? A: No SQL Generated ++++++++++++++++++++++++++++ [66] Q: What is the gender breakdown of the most popular baby names? A: No SQL Generated ++++++++++++++++++++++++++++ [67] Q: What are the most popular baby names in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [68] Q: What are the trends in baby name popularity over time? A: No SQL Generated ++++++++++++++++++++++++++++ [69] Q: What are the most popular baby names for each letter of the alphabet? A: No SQL Generated ++++++++++++++++++++++++++++ [70] Q: What are the most popular baby names in each state? A: ++++++++++++++++++++++++++++ [71] Q: What are the most popular baby names in the US overall? A: No SQL Generated ++++++++++++++++++++++++++++ [72] Q: What are the trends in baby name popularity over time? A: No SQL Generated ++++++++++++++++++++++++++++ [73] Q: Are there any names that are popular in one state but not in others? A: SELECT actor_login, actor_location, COUNT(*) AS count FROM github_events GROUP BY actor_login, actor_location HAVING COUNT(*) > 1 AND COUNT(*) = (SELECT COUNT(*) FROM github_events WHERE actor_login = github_events.actor_login GROUP BY actor_location HAVING COUNT(*) = 1); ++++++++++++++++++++++++++++ [74] Q: Are there any names that are more popular for one gender than the other? A: SELECT actor_login, COUNT(*) AS count FROM github_events GROUP BY actor_login HAVING COUNT(*) > 1 ORDER BY count DESC; ++++++++++++++++++++++++++++ [75] Q: What is the most common type of school in the dataset? A: SELECT type, COUNT(*) AS type_count FROM github_events GROUP BY type ORDER BY type_count DESC LIMIT 1; ++++++++++++++++++++++++++++ [76] Q: What is the average number of students served by each school? A: SELECT AVG(students) FROM school; No SQL Generated. ++++++++++++++++++++++++++++ [77] Q: What is the most common funding type for schools? A: No SQL Generated ++++++++++++++++++++++++++++ [78] Q: What is the average distance between schools? A: No SQL Generated ++++++++++++++++++++++++++++ [79] Q: What is the most common type of educational operations code? A: SELECT type, COUNT(*) AS count FROM github_events WHERE type IN ('PushEvent', 'PullRequestEvent', 'IssueCommentEvent', 'IssuesEvent', 'CreateEvent', 'ForkEvent', 'PullRequestReviewCommentEvent', 'PullRequestReviewEvent', 'ReleaseEvent', 'WatchEvent') AND language = 'Educational' GROUP BY type ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [80] Q: What is the average percentage of students eligible for free meals in California schools? A: No SQL Generated ++++++++++++++++++++++++++++ [81] Q: What is the average percentage of students eligible for FRPM in California schools? A: No SQL Generated ++++++++++++++++++++++++++++ [82] Q: What is the breakdown of school types in California? A: No SQL Generated ++++++++++++++++++++++++++++ [83] Q: What is the breakdown of educational option types in California? A: No SQL Generated ++++++++++++++++++++++++++++ [84] Q: What is the breakdown of NSLP provision status in California? A: SELECT state, COUNT(*) AS count FROM github_events WHERE state = 'California' GROUP BY state; ++++++++++++++++++++++++++++ [85] Q: What school district has the highest average SAT score in reading? A: No SQL Generated ++++++++++++++++++++++++++++ [86] Q: What school has the highest average SAT score in math? A: No SQL Generated ++++++++++++++++++++++++++++ [87] Q: What school district has the highest percentage of students scoring above 1500 on the SAT? A: No SQL Generated ++++++++++++++++++++++++++++ [88] Q: What is the average SAT score in reading for schools with more than 500 students enrolled? A: No SQL Generated ++++++++++++++++++++++++++++ [89] Q: What is the average SAT score in math for schools with fewer than 200 students enrolled? A: No SQL Generated ++++++++++++++++++++++++++++ [90] Q: What is the most popular surname in each year? A: SELECT actor_login, COUNT(*) AS count, event_year FROM github_events GROUP BY actor_login, event_year ORDER BY count DESC; ++++++++++++++++++++++++++++ [91] Q: What is the most popular surname among different ethnic groups? A: No SQL Generated ++++++++++++++++++++++++++++ [92] Q: What is the trend of the most popular surnames over the years? A: No SQL Generated ++++++++++++++++++++++++++++ [93] Q: What is the proportion of surnames that are shared by different ethnic groups? A: No SQL Generated ++++++++++++++++++++++++++++ [94] Q: What is the proportion of surnames that are unique to each ethnic group? A: SELECT ethnic_group, COUNT(DISTINCT surname) / COUNT(*) AS proportion_unique_surnames FROM people GROUP BY ethnic_group; ++++++++++++++++++++++++++++ [95] Q: What is the most common type of weapon used in incidents? A: No SQL Generated ++++++++++++++++++++++++++++ [96] Q: What is the most common subject status in incidents? A: SELECT state, COUNT(*) AS count FROM github_events GROUP BY state ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [97] Q: What is the average number of officers involved in incidents? A: SELECT AVG(actor_id) FROM github_events WHERE type IN ('PushEvent', 'PullRequestEvent', 'IssueCommentEvent', 'IssuesEvent', 'CreateEvent', 'ForkEvent', 'PullRequestReviewCommentEvent', 'PullRequestReviewEvent', 'ReleaseEvent', 'WatchEvent'); ++++++++++++++++++++++++++++ [98] Q: What is the average number of subjects involved in incidents? A: SELECT AVG(push_distinct_size) FROM github_events WHERE type IN ('PushEvent', 'PullRequestEvent', 'IssueCommentEvent', 'IssuesEvent', 'CreateEvent', 'ForkEvent', 'PullRequestReviewCommentEvent', 'PullRequestReviewEvent', 'ReleaseEvent', 'WatchEvent'); ++++++++++++++++++++++++++++ [99] Q: What is the most common grand jury disposition for incidents? A: No SQL Generated ++++++++++++++++++++++++++++ [100] Q: What is the most common race of officers involved in cases? A: SELECT actor_location, COUNT(*) AS count FROM github_events GROUP BY actor_location ORDER BY count DESC LIMIT 1; ++++++++++++++++++++++++++++ [101] Q: What is the gender breakdown of officers involved in cases? A: No SQL Generated ++++++++++++++++++++++++++++ [102] Q: Are there any patterns in the last names of officers involved in cases? A: SELECT actor_login, COUNT(*) FROM github_events GROUP BY actor_login ORDER BY actor_login; ++++++++++++++++++++++++++++ [103] Q: Are there any patterns in the first names of officers involved in cases? A: SELECT actor_login, COUNT(*) AS count FROM github_events GROUP BY actor_login ORDER BY count DESC; ++++++++++++++++++++++++++++ [104] Q: Are there any patterns in the full names of officers involved in cases? A: SELECT actor_login, COUNT(*) AS count FROM github_events GROUP BY actor_login ORDER BY count DESC; ++++++++++++++++++++++++++++ [105] Q: What is the most common race of the subjects? A: No SQL Generated ++++++++++++++++++++++++++++ [106] Q: What is the gender breakdown of the subjects? A: No SQL Generated ++++++++++++++++++++++++++++ [107] Q: Are there any patterns in the last names of the subjects? A: SELECT actor_login, COUNT(*) FROM github_events GROUP BY actor_login ORDER BY COUNT(*) DESC; ++++++++++++++++++++++++++++ [108] Q: Are there any correlations between race and gender of the subjects? A: No SQL Generated ++++++++++++++++++++++++++++ [109] Q: Are there any correlations between the first and last names of the subjects? A: No SQL Generated ++++++++++++++++++++++++++++ [110] Q: What is the median age of the population in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [111] Q: What is the median household income in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [112] Q: What is the percentage of the population that is foreign-born in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [113] Q: What is the median value of owner-occupied homes in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [114] Q: What is the percentage of the population living below the poverty line in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [115] Q: What is the median age of people living in each congressional district? A: No SQL Generated ++++++++++++++++++++++++++++ [116] Q: What is the median household income in each congressional district? A: No SQL Generated ++++++++++++++++++++++++++++ [117] Q: What is the racial breakdown of each congressional district? A: No SQL Generated ++++++++++++++++++++++++++++ [118] Q: What is the foreign-born population in each congressional district? A: No SQL Generated. ++++++++++++++++++++++++++++ [119] Q: What is the median value of owner-occupied homes in each congressional district? A: No SQL Generated ++++++++++++++++++++++++++++ [120] Q: What is the median age of people living in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [121] Q: What is the median household income for each state? A: No SQL Generated ++++++++++++++++++++++++++++ [122] Q: What is the total population of each place? A: SELECT actor_location, COUNT(*) AS Total_Population FROM github_events GROUP BY actor_location; ++++++++++++++++++++++++++++ [123] Q: What is the percentage of foreign-born population in each state? A: No SQL Generated ++++++++++++++++++++++++++++ [124] Q: What is the median value of owner-occupied homes in each state? A: No SQL Generated