| q45 |
R-SET |
NOT_EQUAL |
type |
|
What is the average writing score of each of the schools managed by Ricci Ulrich? List the schools and the corresponding average writing scores. |
| q149 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Please list the account types that are not eligible for loans, and the average income of residents in the district where the account is located exceeds $8000 but is no more than $9000. |
| q168 |
R-SET |
NOT_EQUAL |
type |
|
What percentage of clients who opened their accounts in the district with an average salary of over 10000 are women? |
| q173 |
R-SET |
NOT_EQUAL |
multiplicity |
|
How often does account number 3 request an account statement to be released? What was the aim of debiting 3539 in total? |
| q206 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What elements are in the TR004_8_9 bond atoms? |
| q240 |
R-SET |
NOT_EQUAL |
multiplicity |
|
List all the elements of the toxicology of the molecule "TR004". |
| q245 |
R-SET |
NOT_EQUAL |
type |
|
What is the average number of bonds the atoms with the element iodine have? |
| q249 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What are the elements of the atoms of TR144_8_19? |
| q255 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What proportion of single bonds are carcinogenic? Please provide your answer as a percentage with five decimal places. |
| q268 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What are the elements for bond id TR001_10_11? |
| q440 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Which foreign language used by "A Pedra Fellwar"? |
| q462 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What's the Italian name of the set of cards with "Ancestor's Chosen" is in? |
| q477 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Which of these artists have designed a card in the set Coldsnap, Jeremy Jarvis, Aaron Miller or Chippy? |
| q487 |
R-SET |
NOT_EQUAL |
type |
|
What is the percentage of incredibly powerful cards in the set Coldsnap? |
| q790 |
R-SET |
NOT_EQUAL |
type |
|
Calculate the difference between Emil Blonsky's weight and Charles Chandler's weight. |
| q800 |
R-SET |
NOT_EQUAL |
type |
|
Calculate the percentage of superheroes with blue eyes. |
| q850 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Please give the name of the race held on the circuits in Germany. |
| q857 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Give the coordinate position for Abu Dhabi Grand Prix. |
| q879 |
R-ORD |
EQUAL |
|
ordering-over-numeric-text |
For the driver who set the fastest lap speed, what is his nationality? |
| q1035 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Give the team_fifa_api_id of teams with more than 50 but less than 60 build-up play speed. |
| q1130 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What are the short name of team who played safe while creating chance of passing? |
| q1340 |
R-SET |
NOT_EQUAL |
other |
float-aggregate-order |
Calculate the difference of the total amount spent in all events by the Student_Club in year 2019 and 2020. |
| q1361 |
R-SET |
EQUAL |
|
float-aggregate-order |
What is the total cost of the pizzas for all the events? |
| q1380 |
R-SET |
EQUAL |
|
float-aggregate-order |
What is the total amount of money spent for food? |
| q1410 |
R-SET |
EQUAL |
|
float-aggregate-order |
List out the full name and total cost that member id "rec4BLdZHS2Blfp4v" incurred? |
| q1432 |
R-SET |
NOT_EQUAL |
type |
|
Among the members with t-shirt size of medium, what is the percentage of the amount 50 received by the Student_Club? |
| q1435 |
R-SET |
NOT_EQUAL |
multiplicity |
|
List the names of closed event as "game" that was closed from 3/15/2019 to 3/20/2020. |
| q1457 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Give the full name and contact number of members who had to spend more than average on each expense. |
| q1506 |
R-SET |
NOT_EQUAL |
multiplicity |
|
Please list the product descriptions of the transactions taken place in the gas stations in the Czech Republic. |
| q1514 |
R-SET |
NOT_EQUAL |
multiplicity |
|
What kind of currency did the customer paid at 16:25:00 in 2012/8/24? |
| q1529 |
R-SET |
NOT_EQUAL |
type |
not-a-function-of-the-data |
What is the amount spent by customer "38508" at the gas stations? How much had the customer spent in January 2012? |
| q1472 |
|
ERROR |
|
|
prediction: execute: execute: column "segment" does not exist LINE 4: AND segment = 'LAM' ^ |
| q1481 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "is" |
| q1501 |
|
ERROR |
|
|
prediction: execute: execute: function substring(date, integer, integer) does not exist LINE 4: WHERE SUBSTRING(transactions_1k.date, 1, 6) = '201306' ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q1525 |
|
ERROR |
|
|
prediction: execute: execute: column reference "customerid" is ambiguous LINE 2: SELECT COUNT(DISTINCT customerid) ^ |
| q1531 |
|
ERROR |
|
|
prediction: execute: execute: division by zero |
| q1533 |
|
ERROR |
|
|
prediction: execute: execute: division by zero |
| q1317 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "s" |
| q1339 |
|
ERROR |
|
|
prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 4: WHERE (EXTRACT(MONTH FROM expense_date) IN (9, 10)) AND (mem... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q1359 |
|
ERROR |
|
|
prediction: execute: execute: invalid input syntax for type double precision: "N/A" LINE 2: ... SUM(b1.amount) IS NULL OR SUM(b2.amount) IS NULL THEN 'N/A' ^ |
| q1371 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "s" |
| q1399 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "s" |
| q1149 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "AS" |
| q1150 |
|
ERROR |
|
|
prediction: execute: execute: function year(date) does not exist LINE 3: WHERE YEAR(Birthday) > 1930 AND Sex = 'F' ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q1153 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1155 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "tables" |
| q1156 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.Patient_ID ^ |
| q1157 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1162 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1164 |
|
ERROR |
|
|
prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^ |
| q1166 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "generate" |
| q1168 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "provided" |
| q1169 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1171 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "`" |
| q1175 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "Date" |
| q1179 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1185 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near ")" |
| q1187 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1189 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "`" |
| q1192 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1195 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1198 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1201 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1205 |
|
ERROR |
|
|
prediction: statement: the text does not parse: unterminated quoted string at or near "'t generate the exact PostgreSQL query as the structure and fields of the tables are not provided. However, I can provide a general structure of the query based on your question and the external knowledge provided." |
| q1208 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1209 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1220 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1225 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "generate" |
| q1227 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.patient_id ^ |
| q1229 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1231 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^ |
| q1232 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.Patient_ID ^ |
| q1235 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.Patient_ID ^ |
| q1238 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.Patient_ID ^ |
| q1239 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.ID = Examination.Patient_ID ^ |
| q1241 |
|
ERROR |
|
|
prediction: execute: execute: column e.patient_id does not exist LINE 6: ...NT(*) FROM Patient p JOIN Examination e ON p.id = e.patient_... ^ |
| q1242 |
|
ERROR |
|
|
prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination E ON P.PatientID = E.PatientID ^ |
| q1243 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1247 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1251 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1252 |
|
ERROR |
|
|
prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^ |
| q1254 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "`" |
| q1255 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1256 |
|
ERROR |
|
|
prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^ |
| q1257 |
|
ERROR |
|
|
prediction: execute: execute: column p.patientid does not exist LINE 3: JOIN Examination e ON p.PatientID = e.PatientID ^ |
| q1265 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patient_id does not exist LINE 3: JOIN Examination ON Patient.patient_id = Examination.patient... ^ |
| q1267 |
|
ERROR |
|
|
prediction: execute: execute: column e.patient_id does not exist LINE 3: JOIN Examination e ON p.id = e.patient_id ^ |
| q1270 |
|
ERROR |
|
|
prediction: execute: execute: column examination.patient_id does not exist LINE 3: JOIN Examination ON Patient.id = Examination.patient_id ^ |
| q1275 |
|
ERROR |
|
|
prediction: execute: execute: column patient.patientid does not exist LINE 3: JOIN Examination ON Patient.PatientID = Examination.PatientI... ^ |
| q1281 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "the" |
| q1302 |
|
ERROR |
|
|
prediction: execute: execute: column p.patient_id does not exist LINE 3: JOIN Examination e ON p.patient_id = e.patient_id ^ |
| q1029 |
|
ERROR |
|
|
prediction: execute: execute: column "team_id" does not exist LINE 1: SELECT team_id, buildUpPlaySpeed ^ |
| q1031 |
|
ERROR |
|
|
prediction: execute: execute: function age(date, text) does not exist LINE 1: SELECT Player.player_name, EXTRACT(YEAR FROM AGE(CURRENT_DAT... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q1036 |
|
ERROR |
|
|
prediction: execute: execute: function strftime(unknown, text) does not exist LINE 8: WHERE buildUpPlayPassing IS NOT NULL AND strftime('%Y', ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q1037 |
|
ERROR |
|
|
prediction: execute: execute: column "preferred_foot" does not exist LINE 1: SELECT (DIVIDE(COUNT(preferred_foot = 'left'), COUNT(player_... ^ |
| q1040 |
|
ERROR |
|
|
prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^ |
| q1044 |
|
ERROR |
|
|
prediction: execute: execute: function pg_catalog.extract(unknown, text) does not exist LINE 3: WHERE EXTRACT(YEAR FROM birthday) = 1970 AND EXTRACT(MONTH F... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q1048 |
|
ERROR |
|
|
prediction: execute: execute: function strftime(unknown, text) does not exist LINE 4: WHERE p.player_name = 'Gabriel Tamas' AND strftime('%Y', pa.... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q1058 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "generate" |
| q1068 |
|
ERROR |
|
|
prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.id ^ |
| q1076 |
|
ERROR |
|
|
prediction: execute: execute: column "player_name" does not exist LINE 1: SELECT (AVG(ball_control) FILTER (WHERE player_name = 'Abdou... ^ |
| q1084 |
|
ERROR |
|
|
prediction: execute: execute: column player_attributes.player_id does not exist LINE 4: ON Player.id = Player_Attributes.player_id ^ |
| q1088 |
|
ERROR |
|
|
prediction: execute: execute: column player.player_id does not exist LINE 4: ON Player.player_id = Player_Attributes.player_id ^ |
| q1092 |
|
ERROR |
|
|
prediction: execute: execute: column "league_name" does not exist LINE 1: SELECT league_name ^ |
| q1094 |
|
ERROR |
|
|
prediction: execute: execute: column "player_name" does not exist LINE 1: ...ELECT overall_rating FROM Player_Attributes WHERE player_nam... ^ |
| q1096 |
|
ERROR |
|
|
prediction: execute: execute: column player_attributes.player_id does not exist LINE 3: JOIN Player ON Player_Attributes.player_id = Player.player_i... ^ |
| q1098 |
|
ERROR |
|
|
prediction: execute: execute: column "team_attributes.chancecreationpassingclass" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...ELECT MAX(Team_Attributes.chanceCreationPassing), Team_Attri... ^ |
| q1102 |
|
ERROR |
|
|
prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^ |
| q1103 |
|
ERROR |
|
|
prediction: execute: execute: column "player_id" does not exist LINE 3: WHERE player_id = (SELECT id FROM Player WHERE player_name =... ^ |
| q1105 |
|
ERROR |
|
|
prediction: execute: execute: column "player_id" does not exist LINE 3: WHERE player_id = ( ^ |
| q1107 |
|
ERROR |
|
|
prediction: execute: execute: column "player_name" does not exist LINE 3: WHERE player_name = 'Kevin Constant' ^ |
| q1110 |
|
ERROR |
|
|
prediction: execute: execute: column team_attributes.build_up_play_passing_class does not exist LINE 1: SELECT team_attributes.build_up_play_passing_class ^ |
| q1113 |
|
ERROR |
|
|
prediction: execute: execute: column team_attributes.defence_aggression_class does not exist LINE 1: SELECT team_attributes.defence_aggression_class ^ HINT: Perhaps you meant to reference the column "team_attributes.defenceaggressionclass". |
| q1114 |
|
ERROR |
|
|
prediction: execute: execute: column "player_id" does not exist LINE 3: WHERE player_id = (SELECT id FROM Player WHERE player_name =... ^ |
| q1115 |
|
ERROR |
|
|
prediction: execute: execute: column "player_name" does not exist LINE 4: WHERE player_name = 'Landon Donovan' AND date = '2013-0... ^ |
| q1116 |
|
ERROR |
|
|
prediction: execute: execute: column player_attributes.player_id does not exist LINE 4: ON Player.id = Player_Attributes.player_id ^ |
| q1122 |
|
ERROR |
|
|
prediction: execute: execute: column player.player_id does not exist LINE 4: ON Player.player_id = Player_Attributes.player_id ^ |
| q1124 |
|
ERROR |
|
|
prediction: execute: execute: column player.name does not exist LINE 1: SELECT Player.name ^ |
| q1134 |
|
ERROR |
|
|
prediction: execute: execute: column "player_id" does not exist LINE 1: ...LECT (SELECT jumping FROM Player_Attributes WHERE player_id ... ^ |
| q1135 |
|
ERROR |
|
|
prediction: execute: execute: column "player_id" does not exist LINE 1: SELECT player_id ^ |
| q1136 |
|
ERROR |
|
|
prediction: execute: execute: column p.player_id does not exist LINE 3: JOIN Player_Attributes pa ON p.player_id = pa.player_id ^ |
| q1141 |
|
ERROR |
|
|
prediction: execute: execute: column team.team_id does not exist LINE 4: ON Team.team_id = Team_Attributes.team_id ^ |
| q1144 |
|
ERROR |
|
|
prediction: execute: execute: column player.player_id does not exist LINE 3: JOIN Player_Attributes ON Player.player_id = Player_Attribut... ^ |
| q1147 |
|
ERROR |
|
|
prediction: execute: execute: column player.player_id does not exist LINE 4: ON Player.player_id = Player_Attributes.player_id ^ |
| q1148 |
|
ERROR |
|
|
prediction: execute: execute: column "height" does not exist LINE 1: SELECT (COUNT(*) FILTER (WHERE height < 180 AND overall_rati... ^ |
| q861 |
|
ERROR |
|
|
prediction: execute: execute: column reference "number" is ambiguous LINE 1: SELECT number FROM qualifying ^ |
| q880 |
|
ERROR |
|
|
prediction: execute: execute: operator does not exist: text - text LINE 4: - ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. |
| q892 |
|
ERROR |
|
|
prediction: execute: execute: column "drivers.forename" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT drivers.forename, drivers.surname, MAX(results.points... ^ |
| q894 |
|
ERROR |
|
|
prediction: execute: execute: column "drivers.forename" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT MIN(results.milliseconds), drivers.forename, drivers.... ^ |
| q898 |
|
ERROR |
|
|
prediction: execute: execute: function year(timestamp with time zone) does not exist LINE 1: SELECT MIN(YEAR(CURRENT_TIMESTAMP) - YEAR(dob)) AS age, fore... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q909 |
|
ERROR |
|
|
prediction: execute: execute: column "country" does not exist LINE 1: SELECT (COUNT(*) FILTER (WHERE country = 'Germany' AND name ... ^ |
| q944 |
|
ERROR |
|
|
prediction: execute: execute: column "last_driver_time" does not exist LINE 1: SELECT ((results.time - last_driver_time) / last_driver_time... ^ |
| q960 |
|
ERROR |
|
|
prediction: execute: execute: function avg(text) does not exist LINE 1: SELECT AVG(fastestlapspeed) ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q962 |
|
ERROR |
|
|
prediction: execute: execute: column reference "driverid" is ambiguous LINE 1: SELECT (COUNT(driverid) FILTER (WHERE EXTRACT(YEAR FROM dob)... ^ |
| q963 |
|
ERROR |
|
|
prediction: execute: execute: operator does not exist: text < integer LINE 4: WHERE d.nationality = 'French' AND l.time < 120 ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. |
| q978 |
|
ERROR |
|
|
prediction: execute: execute: column "circuits.location" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT count(*), location, lat, lng ^ |
| q988 |
|
ERROR |
|
|
prediction: execute: execute: function avg(text) does not exist LINE 1: ...vers.driverid, drivers.forename, drivers.surname, AVG(pitSto... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q772 |
|
ERROR |
|
|
prediction: execute: execute: column colour.eye_colour does not exist LINE 1: SELECT colour.eye_colour, colour.hair_colour, colour.skin_co... ^ |
| q572 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "FROM" |
| q639 |
|
ERROR |
|
|
prediction: execute: execute: division by zero |
| q358 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "FROM" |
| q415 |
|
ERROR |
|
|
prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT (DIVIDE(COUNT(cards.hascontentwarning = 0), COUNT(car... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q416 |
|
ERROR |
|
|
prediction: execute: execute: argument of AND must be type boolean, not type bigint LINE 1: SELECT (COUNT(*) FILTER (WHERE cards.power IS NULL OR cards.... ^ |
| q480 |
|
ERROR |
|
|
prediction: execute: execute: column reference "flavortext" is ambiguous LINE 1: SELECT flavortext ^ |
| q200 |
|
ERROR |
|
|
prediction: statement: the text does not parse: unterminated quoted string at or near "'" |
| q219 |
|
ERROR |
|
|
prediction: statement: the text does not parse: unterminated quoted string at or near "'" |
| q234 |
|
ERROR |
|
|
prediction: execute: execute: column reference "bond_id" is ambiguous LINE 1: SELECT COUNT(bond_id) ^ |
| q248 |
|
ERROR |
|
|
prediction: statement: the text does not parse: unterminated quoted string at or near "'" |
| q253 |
|
ERROR |
|
|
prediction: statement: the text does not parse: unterminated quoted string at or near "'" |
| q260 |
|
ERROR |
|
|
prediction: statement: the text does not parse: unterminated quoted string at or near "'" |
| q263 |
|
ERROR |
|
|
prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT (DIVIDE(SUM(CASE WHEN atom.element = 'cl' THEN 1 ELSE... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q273 |
|
ERROR |
|
|
prediction: execute: execute: function divide(bigint, bigint) does not exist LINE 1: SELECT (DIVIDE(SUM(CASE WHEN atom.element = 'cl' THEN 1 ELSE... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
| q11 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "5" |
| q12 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "Meal" |
| q17 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "," |
| q23 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "`" |
| q26 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "`" |
| q31 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "`" |
| q62 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "`" |
| q82 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "FROM" |
| q83 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "Provision" |
| q85 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "." |
| q92 |
|
ERROR |
|
|
prediction: execute: execute: column reference "district_id" is ambiguous LINE 1: SELECT COUNT(DISTINCT district_id) ^ |
| q94 |
|
ERROR |
|
|
prediction: statement: the text does not parse: syntax error at or near "is" |
| q129 |
|
ERROR |
|
|
prediction: execute: execute: operator does not exist: date ~~ unknown LINE 5: WHERE trans.type = 'VYDAJ' AND trans.date LIKE '1996-01%' ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. |