legoskier/Qwen2.5-7B-distillation-lora_3_2
Text Generation • 8B • Updated
id stringlengths 16 16 | messages listlengths 6 10 | metadata dict |
|---|---|---|
dbbench_sft_0000 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"6246.9"
],
"sql": "SELECT AVG(`Uplink (MHz)`) FROM `Satellite Communications Data` WHERE `Status` = 'Standby';",
"table_name": "Satellite Communications Data",
"type": "aggregation-AVG",
"where_col": null,
"wrong_sql": n... |
dbbench_sft_0001 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Football Matches 2016` (`Date`, `Venue`, `Opponent`, `Score`, `Competition`) VALUES ('Alpha', 'Epsilon', 'Philadelphia', 'Gamma', 'Romania');",
"table_name": "Football Matches 2016",
"type": "IN... |
dbbench_sft_0002 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Race Results` SET `Finish` = '56', `Start` = '48' WHERE `Car` = '#86';",
"table_name": "Race Results",
"type": "UPDATE",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0003 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"8.0"
],
"sql": "SELECT AVG(`Silver`) FROM `1992_Olympic_Medal_Tally` WHERE `Nation` = 'Kenya';",
"table_name": "1992_Olympic_Medal_Tally",
"type": "aggregation-AVG",
"where_col": null,
"wrong_sql": null,
"wrong_val": n... |
dbbench_sft_0004 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `World Higher Education Data` SET `Score` = '54.5', `Country` = 'New Entry' WHERE `Name` = 'Cornell';",
"table_name": "World Higher Education Data",
"type": "UPDATE",
"where_col": null,
"wrong_sql... |
dbbench_sft_0005 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"Yekaterinburg",
"Samara",
"Chelyabinsk"
],
"sql": "SELECT `Region` FROM `Population by Age Group and Region in Germany` WHERE `18 to 19` > 15291;",
"table_name": "Population by Age Group and Region in Germany",
"type... |
dbbench_sft_0006 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Area\n(km²)",
"error_reason": "special",
"label": [
"done"
],
"sql": "UPDATE `Islands of Philippines` SET `Area\n(sq mi)` = '34.0', `Country/Region` = 'Updated Value', `Area\n(km²)` = '78.0' WHERE `Island` = 'Shetland';",
"table_name": "Islands of Philippines",
"... |
dbbench_sft_0007 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"3459.0"
],
"sql": "SELECT MAX(`Area\n(sq ft)`) FROM `Real Estate 2022` WHERE `Address` = '860 Main St';",
"table_name": "Real Estate 2022",
"type": "aggregation-MAX",
"where_col": null,
"wrong_sql": null,
"wrong_val": ... |
dbbench_sft_0008 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Name",
"error_reason": "reserved",
"label": [
"done"
],
"sql": "UPDATE `Intelsat Satellite Fleet` SET `Downlink (MHz)` = '26.6', `Uplink (MHz)` = '44.2' WHERE `Name` = 'SES-27';",
"table_name": "Intelsat Satellite Fleet",
"type": "UPDATE_error_recovery",
"where... |
dbbench_sft_0009 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Position",
"error_reason": "reserved",
"label": [
"done"
],
"sql": "INSERT INTO `Marine_Corps_Officers_List` (`Name`, `From`, `To`, `Position`, `Unit`) VALUES ('Istanbul', 'Dallas', 'Alpha', 'Epsilon', 'Hungary');",
"table_name": "Marine_Corps_Officers_List",
"ty... |
dbbench_sft_0010 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"1"
],
"sql": "SELECT COUNT(*) FROM `2007 Formula One Season` WHERE `Driver` = 'Nancy Lewis';",
"table_name": "2007 Formula One Season",
"type": "counting",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0011 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Satellite_Communications_Data` (`Name`, `Uplink (MHz)`, `Downlink (MHz)`, `System`, `Status`) VALUES ('Beta', '99.4', '88.8', 'Alpha', 'Beta');",
"table_name": "Satellite_Communications_Data",
"... |
dbbench_sft_0012 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Country/Region",
"error_reason": "special",
"label": [
"1"
],
"sql": "SELECT COUNT(*) FROM `Islands of Caribbean` WHERE `Country/Region` = 'Israel';",
"table_name": "Islands of Caribbean",
"type": "counting_error_recovery",
"where_col": null,
"wrong_sql": "SE... |
dbbench_sft_0013 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Type",
"error_reason": "reserved",
"label": [
"150.0"
],
"sql": "SELECT SUM(`Duration`) FROM `TV Schedule Winter 2024` WHERE `Type` = 'News';",
"table_name": "TV Schedule Winter 2024",
"type": "aggregation-SUM_error_recovery",
"where_col": null,
"wrong_sql": ... |
dbbench_sft_0014 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"21"
],
"sql": "SELECT `Silver` FROM `Youth Olympics Medal Count` WHERE `Nation` = 'Israel';",
"table_name": "Youth Olympics Medal Count",
"type": "other",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0015 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Economics Research Papers` (`Title`, `Year`, `Citations`, `Authors`, `Venue`) VALUES ('Philadelphia', '50', '58', 'Portugal', 'Brazil');",
"table_name": "Economics Research Papers",
"type": "INS... |
dbbench_sft_0016 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Northern Census Data` SET `15 to 17` = '39', `18 to 19` = '2' WHERE `Region` = 'Nizhny Novgorod';",
"table_name": "Northern Census Data",
"type": "UPDATE",
"where_col": null,
"wrong_sql": null,
... |
dbbench_sft_0017 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Activators ligands --> Gq-GPCRs",
"error_reason": "special",
"label": [
"done"
],
"sql": "INSERT INTO `Pharmacological Data Table` (`Cell type`, `Organ/System`, `Activators ligands --> Gq-GPCRs`, `Effects`) VALUES ('Stephanie Harris', 'Beta', 'Michelle Taylor', 'Gamm... |
dbbench_sft_0018 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Marine_Corps_Officers_List` SET `Position` = 'Warsaw', `To` = 'New Entry' WHERE `Name` = 'COL George Ramirez';",
"table_name": "Marine_Corps_Officers_List",
"type": "UPDATE",
"where_col": null,
"... |
dbbench_sft_0019 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Islands of Philippines` SET `Area\n(sq mi)` = '92.0', `Country/Region` = 'James Perez' WHERE `Island` = 'Arran';",
"table_name": "Islands of Philippines",
"type": "UPDATE",
"where_col": null,
"wr... |
dbbench_sft_0020 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"22.0"
],
"sql": "SELECT MAX(`Rank`) FROM `Asia_Higher_Education_Data`;",
"table_name": "Asia_Higher_Education_Data",
"type": "aggregation-MAX",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0021 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"1"
],
"sql": "SELECT COUNT(*) FROM `Actress_Filmography` WHERE `Genre` = 'Musical';",
"table_name": "Actress_Filmography",
"type": "counting",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0022 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `FDA Approved Medications` SET `Dosage (mg)` = '38.6' WHERE `Name` = 'Lisinopril';",
"table_name": "FDA Approved Medications",
"type": "UPDATE",
"where_col": null,
"wrong_sql": null,
"wrong_val"... |
dbbench_sft_0023 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": "Poland",
"error_col": null,
"error_reason": null,
"label": [
"Borneo"
],
"sql": "SELECT `Island` FROM `World Islands Database` WHERE `Country/Region` = 'Poland';",
"table_name": "World Islands Database",
"type": "other_retry",
"where_col": "Country/Region",
"wrong_sql": "SELECT... |
dbbench_sft_0024 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Islands_of_Greece` SET `Rank` = '38', `Area\n(km²)` = '61.0', `Country/Region` = 'Updated Value' WHERE `Island` = 'Cebu';",
"table_name": "Islands_of_Greece",
"type": "UPDATE",
"where_col": null,
... |
dbbench_sft_0025 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Quentin_Tarantino_Filmography` SET `Genre` = 'Updated Value', `Year` = '19' WHERE `Title` = 'Red Dawn';",
"table_name": "Quentin_Tarantino_Filmography",
"type": "UPDATE",
"where_col": null,
"wron... |
dbbench_sft_0026 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `First Division 2013 Season Standings` (`Date`, `Opponent`, `Result`, `Score`, `Rank`, `Attendance`) VALUES ('Belgium', 'Gamma', 'Alpha', 'Delta', '51', '67');",
"table_name": "First Division 2013 ... |
dbbench_sft_0027 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `2000 Olympic Medal Tally` (`Rank`, `Nation`, `Gold`, `Silver`, `Bronze`, `Total`) VALUES ('56', 'Daniel Ramirez', '63', '26', '29', '48');",
"table_name": "2000 Olympic Medal Tally",
"type": "IN... |
dbbench_sft_0028 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Drug Approval Database` SET `Type` = 'Stephanie Wright', `Date` = 'New Entry' WHERE `Name` = 'Levothyroxine';",
"table_name": "Drug Approval Database",
"type": "UPDATE",
"where_col": null,
"wrong... |
dbbench_sft_0029 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "No",
"error_reason": "reserved",
"label": [
"16.0"
],
"sql": "SELECT MAX(`No`) FROM `Railway Stations France`;",
"table_name": "Railway Stations France",
"type": "aggregation-MAX_error_recovery",
"where_col": null,
"wrong_sql": "SELECT MAX(No) FROM `Railway S... |
dbbench_sft_0030 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": "Neuron",
"error_col": null,
"error_reason": null,
"label": [
"1"
],
"sql": "SELECT COUNT(*) FROM `Pharmacological Data Table` WHERE `Cell type` = 'Neuron';",
"table_name": "Pharmacological Data Table",
"type": "counting_retry",
"where_col": "Cell type",
"wrong_sql": "SELECT COU... |
dbbench_sft_0031 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `NBC_Programming` (`Time`, `Title`, `Duration`, `Type`, `Rating`) VALUES ('Gamma', 'Gamma', '10', 'Epsilon', '71.5');",
"table_name": "NBC_Programming",
"type": "INSERT",
"where_col": null,
"... |
dbbench_sft_0032 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `France_Match_History` SET `Score` = 'Updated Value' WHERE `Date` = 'November 24, 1983';",
"table_name": "France_Match_History",
"type": "UPDATE",
"where_col": null,
"wrong_sql": null,
"wrong_va... |
dbbench_sft_0033 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Real Estate 2021` (`Address`, `Price`, `Area\n(sq ft)`, `Year`, `Level`) VALUES ('United Arab Emirates', '53', '16', '9', '14');",
"table_name": "Real Estate 2021",
"type": "INSERT",
"where_co... |
dbbench_sft_0034 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"Australia",
"Malaysia",
"Belgium"
],
"sql": "SELECT `Nation` FROM `Summer Olympics Medal Count` WHERE `Bronze` < 23;",
"table_name": "Summer Olympics Medal Count",
"type": "comparison",
"where_col": null,
"wrong_... |
dbbench_sft_0035 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Rank",
"error_reason": "reserved",
"label": [
"done"
],
"sql": "INSERT INTO `Summer Olympics Medal Count` (`Rank`, `Nation`, `Gold`, `Silver`, `Bronze`, `Total`) VALUES ('31', 'Beta', '70', '85', '1', '68');",
"table_name": "Summer Olympics Medal Count",
"type": ... |
dbbench_sft_0036 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `European_Championships_Competition_Records` SET `Race 1\nTime` = '82.6' WHERE `Athlete` = 'Jennifer Carter';",
"table_name": "European_Championships_Competition_Records",
"type": "UPDATE",
"where_c... |
dbbench_sft_0037 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Downlink (MHz)",
"error_reason": "special",
"label": [
"done"
],
"sql": "INSERT INTO `Satellite Communications Data` (`Name`, `Uplink (MHz)`, `Downlink (MHz)`, `System`, `Status`) VALUES ('New Zealand', '78.2', '38.8', 'Gamma', 'Deborah Collins');",
"table_name": "... |
dbbench_sft_0038 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `TV_Schedule_Summer_2024` SET `Title` = 'Helsinki', `Duration` = '25' WHERE `Time` = '7:30';",
"table_name": "TV_Schedule_Summer_2024",
"type": "UPDATE",
"where_col": null,
"wrong_sql": null,
"w... |
dbbench_sft_0039 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"21833.0"
],
"sql": "SELECT SUM(`Year`) FROM `Indianapolis 500 History`;",
"table_name": "Indianapolis 500 History",
"type": "aggregation-SUM",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0040 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Winter_Olympics_Medal_Count` (`Rank`, `Nation`, `Gold`, `Silver`, `Bronze`, `Total`) VALUES ('93', 'Epsilon', '50', '19', '40', '19');",
"table_name": "Winter_Olympics_Medal_Count",
"type": "INS... |
dbbench_sft_0041 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Name",
"error_reason": "reserved",
"label": [
"done"
],
"sql": "UPDATE `Georgia Election Results` SET `Percentage` = '50.7', `Party` = 'New Entry', `Votes` = '25' WHERE `Name` = 'Sarah Anderson';",
"table_name": "Georgia Election Results",
"type": "UPDATE_error_r... |
dbbench_sft_0042 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"1"
],
"sql": "SELECT COUNT(*) FROM `Race_Results` WHERE `Car` = '#29';",
"table_name": "Race_Results",
"type": "counting",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0043 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"1"
],
"sql": "SELECT COUNT(*) FROM `Panthers Season Results` WHERE `Date` = 'July 28, 1982';",
"table_name": "Panthers Season Results",
"type": "counting",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0044 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Indianapolis 500 History` (`Year`, `Car`, `Start`, `Qual`, `Rank`, `Finish`, `Laps`) VALUES ('71', 'Beta', '2', '98.3', '54', '10', '27');",
"table_name": "Indianapolis 500 History",
"type": "IN... |
dbbench_sft_0045 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Major League 2007 Season Standings` (`Date`, `Opponent`, `Result`, `Score`, `Rank`, `Attendance`) VALUES ('Alpha', 'Sydney', 'James Thomas', 'San Jose', '99', '52');",
"table_name": "Major League ... |
dbbench_sft_0046 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Area\n(km²)",
"error_reason": "special",
"label": [
"done"
],
"sql": "UPDATE `Islands of Japan` SET `Rank` = '30', `Area\n(km²)` = '66.3' WHERE `Island` = 'Skye';",
"table_name": "Islands of Japan",
"type": "UPDATE_error_recovery",
"where_col": null,
"wrong_s... |
dbbench_sft_0047 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "UPDATE `Northern_Census_Data` SET `18 to 19` = '21' WHERE `Region` = 'Omsk';",
"table_name": "Northern_Census_Data",
"type": "UPDATE",
"where_col": null,
"wrong_sql": null,
"wrong_val": null
} |
dbbench_sft_0048 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Country/Region",
"error_reason": "special",
"label": [
"done"
],
"sql": "INSERT INTO `Islands of Indonesia` (`Rank`, `Island`, `Area\n(km²)`, `Area\n(sq mi)`, `Country/Region`) VALUES ('29', 'Gamma', '8.0', '32.8', 'Malaysia');",
"table_name": "Islands of Indonesia... |
dbbench_sft_0049 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Status",
"error_reason": "reserved",
"label": [
"3"
],
"sql": "SELECT COUNT(*) FROM `2002_General_Election` WHERE `Status` = 'Withdrawn';",
"table_name": "2002_General_Election",
"type": "counting_error_recovery",
"where_col": null,
"wrong_sql": "SELECT COUNT... |
dbbench_sft_0050 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": null,
"error_reason": null,
"label": [
"done"
],
"sql": "INSERT INTO `Cell_Receptor_Database` (`Cell type`, `Organ/System`, `Activators ligands --> Gq-GPCRs`, `Effects`) VALUES ('Epsilon', 'Delta', 'David Walker', 'Mexico City');",
"table_name": "Cell_Receptor_Datab... |
dbbench_sft_0051 | [
{
"content": "\nI will ask you a question, then you should help me operate a MySQL database with SQL to answer the question.\nYou have to explain the problem and your solution to me and write down your thoughts.\nAfter thinking and explaining thoroughly, every round you can choose to operate or to answer.\nyour... | {
"correct_val": null,
"error_col": "Rank",
"error_reason": "reserved",
"label": [
"#77"
],
"sql": "SELECT `Car` FROM `Rick Mears Career Stats` ORDER BY `Rank` DESC LIMIT 1;",
"table_name": "Rick Mears Career Stats",
"type": "ranking_error_recovery",
"where_col": null,
"wrong_sql": "SELECT `Car`... |