Generate SQL given the statement and table to verify the statement correctly. If statement-relevant column(s) contents are not suitable for SQL comparisons or calculations, map it to a new column with clean content by a new grammar QA("map@"). If mapping to a new column still can not answer the statement with valid SQL, turn to an end-to-end solution by a new grammar QA("ans@"). This grammar aims to solve all the rest of complex statements or tables. CREATE TABLE jason chambers( row_id int, res text, record text, opponent text, method text, event text, round text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id res record opponent method event round 0 win 18 - 5 - 2 dan new submission (rear naked choke) tfc - power fights 1 1 win 17 - 5 - 2 rene gonzalez decision (split) mainstream mma - cold war n / a 2 loss 16 - 5 - 2 tristan yunker submission ( armbar ) tfc 7 - total fight challenge 7 1 */ Q: in mac - midwest absolute challenge , the player be defeat by dan spychalski in 1 round NeuralSQL: SELECT (SELECT opponent, round FROM w WHERE event = "mac - midwest absolute challenge")=("dan spychalski", 1) CREATE TABLE 1943 vfl season( row_id int, home team text, home team score text, away team text, away team score text, venue text, crowd int, date text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id home team home team score away team away team score venue crowd date 0 footscray 10.11 (71) south melbourne 6.14 (50) western oval 7500 1943-06-26 00:00:00 1 collingwood 10.21 (81) melbourne 13.9 (87) victoria park 5000 1943-06-26 00:00:00 2 carlton 15.16 (106) fitzroy 9.13 (67) princes park 12000 1943-06-26 00:00:00 */ Q: western oval be the venue when the home team footscray score 10.11 (71) NeuralSQL: SELECT (SELECT venue FROM w WHERE `home team`="footscray" AND `home team score`="10.11 (71)") = "western oval" CREATE TABLE 2005 pba draft( row_id int, pick int, player text, country of origin text, pba team text, college text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id pick player country of origin pba team college 0 1 jay washington united states air21 express eckerd 1 2 alex cabagnot united states sta lucia realtors hawaii - hilo 2 3 dennis miranda philippines coca - cola tigers feu */ Q: leo najorda be from philippine NeuralSQL: SELECT (SELECT `country of origin` FROM w WHERE player = "leo najorda")="philippines" CREATE TABLE none( row_id int, event text, long course / short course text, year set int, time text, meet text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id event long course / short course year set time meet 0 100 m freestyle long course 2007 54.08 2007 fina world aquatic championships 1 200 m individual medley long course 2011 2:11.23 2011 canadian world championship trials 2 4 x 100 m medley relay long course 2010 3:38.14 2010 pan pacific championships */ Q: in 2009 the record be set in 7:51:80 NeuralSQL: SELECT (SELECT time FROM w WHERE `year set` = 2009)="7:51.8" CREATE TABLE turkish cup( row_id int, round text, clubs remaining int, clubs involved int, winners from previous round real, new entries this round real, leagues entering at this round text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id round clubs remaining clubs involved winners from previous round new entries this round leagues entering at this round 0 first round 156 86 nan 86.0 tff third league & turkish regional amateur league 1 second round 113 108 43.0 65.0 süper lig & tff first league & tff second league 2 third round 59 54 54.0 nan none */ Q: during the 3rd round of the turkish cup , there be no new entry during that stage NeuralSQL: SELECT (SELECT `new entries this round` FROM w WHERE round = 'third round') IS NULL CREATE TABLE turkish cup( row_id int, round text, clubs remaining int, clubs involved int, winners from previous round real, new entries this round real, leagues entering at this round text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id round clubs remaining clubs involved winners from previous round new entries this round leagues entering at this round 0 first round 156 86 nan 86.0 tff third league & turkish regional amateur league 1 second round 113 108 43.0 65.0 süper ligs & tff first league & tff second league 2 third round 59 54 54.0 nan none */ Q: süper lig be the most common league to win a round in the turkish cup NeuralSQL: SELECT QA("ans@what is the most common league?"; `leagues entering at this round`) = 'süper ligs' CREATE TABLE turkish cup( row_id int, round text, clubs remaining int, clubs involved int, winners from previous round real, new entries this round real, leagues entering at this round text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id round clubs remaining clubs involved winners from previous round new entries this round leagues entering at this round 0 first round 156 86 nan 86.0 tff third league & turkish regional amateur league 1 second round 113 108 43.0 65.0 süper lig & tff first league & tff second league 2 third round 59 54 54.0 nan none */ Q: the lowest number of new entry conclude a round in the turkish cup be 5 NeuralSQL: SELECT (SELECT MIN(`new entries this round`) FROM w) = 5 CREATE TABLE cultural interest fraternities and sororities( row_id int, letters text, organization text, nickname text, founding time text, founding university text, type text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id letters organization nickname founding time founding university type 0 αεπ alpha epsilon pi 1 aepi 1913-11-07 00:00:00 new york university fraternity 1 αεφ alpha epsilon phi 2 aephi 1909-10-24 00:00:00 barnard college sorority 2 σαεπ sigma alpha epsilon pi 3 sigma 1998-10-01 00:00:00 university of california , davis sorority */ Q: 4 of the cultural interest fraternity and sorority be fraternity while 3 be a sorority NeuralSQL: SELECT (SELECT (SELECT COUNT(*) FROM w WHERE type = 'fraternity') = 4) AND (SELECT (SELECT COUNT(*) FROM w WHERE type = 'sorority') = 3) CREATE TABLE british records in athletics( row_id int, event text, data text, athlete text, date text, place text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id event data athlete date place 0 5 km t19:29 andi drake 1990-05-27 00:00:00 søfteland , norway 1 5 miles 32:38 + ian mccombie 1985-03-23 00:00:00 york , united kingdom 2 10 km 40:17 chris maddocks 1989-04-30 00:00:00 burrator , united kingdom */ Q: there be 8 different event that take place within the united kingdom NeuralSQL: SELECT (SELECT COUNT(place) FROM w WHERE QA("map@is it in united kingdom?"; place) = 'yes') = 8 CREATE TABLE jeev milkha singh( row_id int, tournament text, wins int, top - 10 int, top - 25 int, events int, cuts made int) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id tournament wins top - 10 top - 25 events cuts made 0 masters tournament 0 0 1 3 2 1 us open 0 0 0 4 3 2 the open championship 0 0 0 2 1 */ Q: the number of cut made in the pga championship tournament be smaller than the number of event NeuralSQL: SELECT (SELECT `cuts made` FROM w WHERE tournament = 'pga championship') < (SELECT events FROM w WHERE tournament = 'pga championship') CREATE TABLE 2008 women 's british open( row_id int, place text, player text, country text, score int, to par int) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id place player country score to par 0 1 juli inkster united states 65 7 1 t2 momoko ueda japan 66 6 2 t2 laura diaz united states 66 6 */ Q: the 3 player from japan have the same score NeuralSQL: SELECT (SELECT COUNT(DISTINCT score) FROM w WHERE country = 'japan' GROUP BY score) = 1 CREATE TABLE espn sunday night football results (1987 - 2005)( row_id int, date text, visiting team text, final score text, host team text, stadium text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id date visiting team final score host team stadium 0 september 11 indianapolis colts 24 - 7 baltimore ravens m&t bank stadium 1 september 18 kansas city chiefs 23 - 17 oakland raiders mcafee coliseum 2 september 25 new york giants 23 - 45 san diego chargers qualcomm stadium */ Q: the hosting team be the new york giant on new year even and the st louis ram on new year 's day NeuralSQL: SELECT (SELECT (SELECT `host team` FROM w WHERE QA("map@is it new year even?"; date) = 'yes') = 'new york giant') AND (SELECT (SELECT `host team` FROM w WHERE QA("map@is it new year's day?"; date) = 'yes') = 'st louis ram') CREATE TABLE 2008 women 's british open( row_id int, place text, player text, country text, score text, to par int) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id place player country score to par 0 t1 yuri fudoh japan 66 + 68 = 134 10 1 t1 jiyai shin south korea 66 + 68 = 134 10 2 3 juli inkster united states 65 + 70 = 135 9 */ Q: kristie kerr , tie for 4th place , finish the round 1 stroke under lorena ochoa of mexico NeuralSQL: SELECT (SELECT (SELECT QA("map@what is the derived score?"; score) FROM w WHERE player = 'cristie kerr') < (SELECT QA("map@what is the derived score?"; score) FROM w WHERE player = 'lorena ochoa' AND country = 'mexico')) AND (SELECT (SELECT place FROM w WHERE player = 'cristie kerr') = "t4") CREATE TABLE connecticut public radio( row_id int, call sign text, frequency text, city of license text, facility id int, erp / power w int, height m ( ft ) real, class text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id call sign frequency city of license facility id erp / power w height m ( ft ) class 0 waic 91.9 fm springfield , ma 1749 230 nan b1 1 wedw - fm 88.5 fm stamford , ct 13619 2000 nan a 2 wnpr 90.5 fm ( hd ) connecticut public radio meriden , ct 13627 18500 nan b */ Q: there be 3 station with a call sign number in the 90s NeuralSQL: SELECT (SELECT COUNT(*) FROM w WHERE QA("map@is it in 90s?"; frequency) = 'yes' GROUP BY `call sign`) = 3 CREATE TABLE 2003 chicago white sox season( row_id int, date text, opponent text, score text, loss text, time text, att int, record text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id date opponent score loss time att record 0 august 1 mariners 12 - 1 garcía (9 - 11) 2:52 39337 58 - 51 1 august 2 mariners 0 - 10 wright (0 - 5) 2:22 45719 58 - 52 2 august 3 mariners 2 - 8 buehrle (9 - 11) 2:57 45632 58 - 53 */ Q: the 2003 chicago white sox game play on 26th august be longer than the game play on 24th august NeuralSQL: SELECT (SELECT time FROM w WHERE date = 'august 26') > (SELECT time FROM w WHERE date = 'august 24') CREATE TABLE 1987 masters tournament( row_id int, place text, player text, country text, score text, to par text, money text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id place player country score to par money 0 t1 larry mize united states 70 + 72 + 72 + 71 = 285 -3 playoff 1 t1 bernhard langer spain 73 + 71 + 70 + 71 = 285 -3 playoff 2 t1 greg norman australia 73 + 74 + 66 + 72 = 285 -3 playoff */ Q: bernhard m. langer have more point than roger maltbie during the 1987 master tournament NeuralSQL: SELECT (SELECT QA("map@what is the total score?"; score) FROM w WHERE player = 'bernhard langer') > (SELECT QA("map@what is the total score?"; score) FROM w WHERE player = 'roger maltbie') CREATE TABLE 1987 masters tournament( row_id int, place text, player text, country text, score text, to par text, money text) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id place player country score to par money 0 t1 larry mize united states 70 + 72 + 72 + 71 = 285 -3 playoff 1 t1 seve ballesteros spain 73 + 71 + 70 + 71 = 285 -3 playoff 2 t1 greg norman australia 73 + 74 + 66 + 72 = 285 -3 playoff */ Q: most of the people who play for the 1987 master tournament be spanish NeuralSQL: SELECT (SELECT(SELECT COUNT(*) FROM w WHERE country = 'spain') / (SELECT COUNT(*) FROM w)) > 0.5 CREATE TABLE 1976 world junior figure skating championships( row_id int, rank int, name text, nation text, points real, places int) /* 3 example rows: SELECT * FROM w LIMIT 3; row_id rank name nation points places 0 1 sherri baier / robin cowan canada 128.39 9 1 2 lorene mitchell / donald mitchell united states 124.94 16 2 3 elizabeth cain / peter cain australia 116.67 33 */ Q: 2 of the 7 top - ranked figure skate team be from france NeuralSQL: SELECT (SELECT (SELECT COUNT(*) FROM w) = 7) AND (SELECT (SELECT COUNT(*) FROM w WHERE nation = 'france') = 2)