CrackSQL/RESULT.md at pypi/0.0.0-alpha · OpenDataBox/CrackSQL

MySQL	SQLGlot	jOOQ	SQLines	GPT-4o	CrackSQL
SELECT SUM( `currency` = 'CZK' ) - SUM( `currency` = 'EUR' ) FROM `customers` WHERE `segment` = 'SME'	SELECT SUM("currency" = 'CZK') - SUM("currency" = 'EUR') FROM "customers" WHERE "segment" = 'SME'	select (sum(case when "currency" = 'CZK' then 1 when not ("currency" = 'CZK') then 0 end) - sum(case when "currency" = 'EUR' then 1 when not ("currency" = 'EUR') then 0 end)) from "customers" where "segment" = 'SME'	SELECT SUM( currency = FROM dual 'CZK' ) - SUM( currency = 'EUR' ) FROM customers WHERE segment = 'SME'	SELECT SUM(CASE WHEN `currency` = 'CZK' THEN 1 ELSE 0 END) - SUM(CASE WHEN `currency` = 'EUR' THEN 1 ELSE 0 END) FROM `customers` WHERE `segment` = 'SME'	SELECT SUM(CASE WHEN "currency" = 'CZK' THEN 1 ELSE 0 END) - SUM(CASE WHEN "currency" = 'EUR' THEN 1 ELSE 0 END) FROM "customers" WHERE "segment" = 'SME'
Source Dialect	ORA-00907: missing right parenthesis Help: https://docs.oracle.com/error-help/db/ora-00907/	√	ORA-00907: missing right parenthesis Help: https://docs.oracle.com/error-help/db/ora-00907/	√	√
SELECT DISTINCT `t3`.`currency` FROM `transactions_1k` AS `t1` INNER JOIN `gasstations` AS `t2` ON `t1`.`gasstationid` = `t2`.`gasstationid` INNER JOIN `customers` AS `t3` ON `t1`.`customerid` = `t3`.`customerid` WHERE `t1`.`date` = '2012-08-24' AND `t1`.`time` = '16:25:00'	SELECT DISTINCT "t3"."currency" FROM "transactions_1k" "t1" INNER JOIN "gasstations" "t2" ON "t1"."gasstationid" = "t2"."gasstationid" INNER JOIN "customers" "t3" ON "t1"."customerid" = "t3"."customerid" WHERE "t1"."date" = '2012-08-24' AND "t1"."time" = '16:25:00'	select distinct "t3"."currency" from "transactions_1k" "t1" join "gasstations" "t2" on "t1"."gasstationid" = "t2"."gasstationid" join "customers" "t3" on "t1"."customerid" = "t3"."customerid" where ( "t1"."date" = '2012-08-24' and "t1"."time" = '16:25:00' )	SELECT DISTINCT t3.currency FROM transactions_1k t1 INNER JOIN gasstations t2 ON t1.gasstationid = t2.gasstationid INNER JOIN customers t3 ON t1.customerid = t3.customerid WHERE t1.date = '2012-08-24' AND t1.time = '16:25:00'	SELECT DISTINCT t3.currency FROM transactions_1k t1 JOIN gasstations t2 ON t1.gasstationid = t2.gasstationid JOIN customers t3 ON t1.customerid = t3.customerid WHERE t1.date = TO_DATE('2012-08-24', 'YYYY-MM-DD') AND t1.time = TO_CHAR(TO_DATE('2012-08-24 16:25:00', 'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI:SS')	SELECT DISTINCT "t3"."currency" FROM "transactions_1k" "t1" INNER JOIN "gasstations" "t2" ON "t1"."gasstationid" = "t2"."gasstationid" INNER JOIN "customers" "t3" ON "t1"."customerid" = "t3"."customerid" WHERE "t1"."date" = TO_DATE('2012-08-24', 'YYYY-MM-DD') AND "t1"."time" = TO_CHAR(TO_DATE('2012-08-24 16:25:00', 'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI:SS')
Source Dialect	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01747: invalid user.table.column, table.column, or column specification Help: https://docs.oracle.com/error-help/db/ora-01747/	ORA-01747: invalid user.table.column, table.column, or column specification Help: https://docs.oracle.com/error-help/db/ora-01747/	√
SELECT CAST( SUM( CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `id` ) FROM `patient` WHERE `diagnosis` = 'RA' AND DATE_FORMAT( CAST( `birthday` AS DATETIME ) , '%Y' ) = '1980'	SELECT CAST(SUM(CASE WHEN "sex" = 'F' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT("id"), 0) FROM "patient" WHERE "diagnosis" = 'RA' AND TO_CHAR(CAST("birthday" AS DATETIME), 'YYYY') = '1980'	select ((cast(sum( case when "sex" = 'F' then 1 else 0 end ) as float) * 100) / count("id")) from "patient" where ( "diagnosis" = 'RA' and DATE_FORMAT( cast("birthday" as timestamp), '%Y' ) = '1980' )	SELECT CAST( SUM( CASE WHEN "sex" = 'F' THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) * 100 / COUNT( "id" ) FROM "patient" WHERE "diagnosis" = 'RA' AND TO_CHAR( CAST( "birthday" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) = '1980' ;	SELECT CAST( SUM( CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( `id` ) FROM `patient` WHERE `diagnosis` = 'RA' AND TO_CHAR( TRUNC( `birthday`, 'YYYY' ), 'YYYY' ) = '1980'	SELECT CAST( SUM( CASE WHEN "sex" = 'F' THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( "id" ) FROM "patient" WHERE "diagnosis" = 'RA' AND TO_CHAR( CAST( "birthday" AS DATE ), 'YYYY' ) = '1980'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	√	√
SELECT CASE WHEN ( `t1`.`sex` = 'F' AND `t2`.`ua` > 6.5 ) OR ( `t1`.`sex` = 'M' AND `t2`.`ua` > 8.0 ) THEN TRUE ELSE FALSE END FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t1`.`id` = 57266	SELECT CASE WHEN ("t1"."sex" = 'F' AND "t2"."ua" > 6.5) OR ("t1"."sex" = 'M' AND "t2"."ua" > 8.0) THEN TRUE ELSE FALSE END FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266	select case when ( ( "t1"."sex" = 'F' and "t2"."ua" > 6.5 ) or ( "t1"."sex" = 'M' and "t2"."ua" > 8.0 ) ) then 1 else 0 end from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where "t1"."id" = 57266	SELECT CASE WHEN ( "t1"."sex" = 'F' AND "t2"."ua" > 6.5 ) OR ( "t1"."sex" = 'M' AND "t2"."ua" > 8.0 ) THEN TRUE ELSE FALSE END FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266	SELECT CASE WHEN ( t1.sex = 'F' AND t2.ua > 6.5 ) OR ( t1.sex = 'M' AND t2.ua > 8.0 ) THEN 1 ELSE 0 END FROM patient t1 INNER JOIN laboratory t2 ON t1.id = t2.id WHERE t1.id = 57266	SELECT CASE WHEN ( "t1"."sex" = 'F' AND "t2"."ua" > 6.5 ) OR ( "t1"."sex" = 'M' AND "t2"."ua" > 8.0 ) THEN 1 ELSE 0 END FROM "patient" "t1" RIGHT JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266
Source Dialect	ORA-00904: "FALSE": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-00904: "FALSE": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-00942: table or view does not exist Help: https://docs.oracle.com/error-help/db/ora-00942/	√
SELECT COUNT( `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`iga` BETWEEN 80 AND 500 AND DATE_FORMAT( CAST( `t1`.`first date` AS DATETIME ) , '%Y' ) > '1990'	SELECT COUNT("t1"."id") FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."iga" BETWEEN 80 AND 500 AND TO_CHAR(CAST("t1"."first date" AS DATETIME), 'YYYY') > '1990'	select count("t1"."id") from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where ( "t2"."iga" between 80 and 500 and DATE_FORMAT( cast("t1"."first date" as timestamp), '%Y' ) > '1990' )	SELECT COUNT( t1.id ) FROM patient t1 INNER JOIN laboratory t2 ON t1.id = t2.id WHERE t2.iga BETWEEN 80 AND 500 AND DATE_FORMAT( CAST( t1.first "date" "AS" DATETIME ) , '%Y' ) > '1990'	SELECT COUNT( t2.id ) FROM patient t1 INNER JOIN laboratory t2 ON t1.id = t2.id WHERE t2.iga BETWEEN 80 AND 500 AND TO_CHAR( TRUNC( t1.first_date ), 'YYYY' ) > '1990'	SELECT COUNT( "t1"."id" ) FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."iga" BETWEEN 80 AND 500 AND TO_CHAR( CAST( "t1"."first date" AS TIMESTAMP ), 'YYYY' ) > '1990'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-00905: missing keyword Help: https://docs.oracle.com/error-help/db/ora-00905/	ORA-00942: table or view does not exist Help: https://docs.oracle.com/error-help/db/ora-00942/	√
SELECT CAST( SUM( `t2`.`overall_rating` ) AS DOUBLE ) / COUNT( `t2`.`id` ) FROM `player` AS `t1` INNER JOIN `player_attributes` AS `t2` ON `t1`.`player_fifa_api_id` = `t2`.`player_fifa_api_id` WHERE `t1`.`player_name` = 'Marko Arnautovic' AND SUBSTR( `t2`.`date` , 1 , 10 ) BETWEEN '2007-02-22' AND '2016-04-21'	SELECT CAST(SUM("t2"."overall_rating") AS DOUBLE PRECISION) / NULLIF(COUNT("t2"."id"), 0) FROM "player" "t1" INNER JOIN "player_attributes" "t2" ON "t1"."player_fifa_api_id" = "t2"."player_fifa_api_id" WHERE "t1"."player_name" = 'Marko Arnautovic' AND SUBSTR("t2"."date", 1, 10) BETWEEN '2007-02-22' AND '2016-04-21'	select (cast(sum("t2"."overall_rating") as float) / count("t2"."id")) from "player" "t1" join "player_attributes" "t2" on "t1"."player_fifa_api_id" = "t2"."player_fifa_api_id" where ( "t1"."player_name" = 'Marko Arnautovic' and substr("t2"."date", 1, 10) between '2007-02-22' and '2016-04-21' )	SELECT CAST( SUM( t2.overall_rating ) AS BINARY_DOUBLE ) / COUNT( t2.id ) FROM player t1 INNER JOIN player_attributes t2 ON t1.player_fifa_api_id = t2.player_fifa_api_id WHERE t1.player_name = 'Marko Arnautovic' AND SUBSTR( t2.date , 1 , 10 ) BETWEEN '2007-02-22' AND '2016-04-21'	SELECT CAST( SUM( t2."overall_rating" ) AS NUMBER ) / COUNT( t2."id" ) FROM player AS t1 INNER JOIN player_attributes AS t2 ON t1."player_fifa_api_id" = t2."player_fifa_api_id" WHERE t1."player_name" = 'Marko Arnautovic' AND TO_DATE( SUBSTR( t2."date", 1, 10 ), 'YYYY-MM-DD' ) BETWEEN TO_DATE( '2007-02-22', 'YYYY-MM-DD' ) AND TO_DATE( '2016-04-21', 'YYYY-MM-DD' )	SELECT CAST( SUM( "t2"."overall_rating" ) AS NUMBER ) / COUNT( "t2"."id" ) FROM "player" "t1" INNER JOIN "player_attributes" "t2" ON "t1"."player_fifa_api_id" = "t2"."player_fifa_api_id" WHERE "t1"."player_name" = 'Marko Arnautovic' AND SUBSTR( "t2"."date" , 1 , 10 ) BETWEEN '2007-02-22' AND '2016-04-21'
Source Dialect	√	√	ORA-01747: invalid user.table.column, table.column, or column specification Help: https://docs.oracle.com/error-help/db/ora-01747/	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( COUNT( CASE WHEN `t2`.`position` <> 1 THEN `t2`.`position` END ) AS DOUBLE ) * 100 / COUNT( `t2`.`driverstandingsid` ) FROM `races` AS `t1` INNER JOIN `driverstandings` AS `t2` ON `t2`.`raceid` = `t1`.`raceid` INNER JOIN `drivers` AS `t3` ON `t3`.`driverid` = `t2`.`driverid` WHERE `t3`.`surname` = 'Hamilton' AND `t1`.`year` >= 2010	SELECT CAST(COUNT(CASE WHEN "t2"."position" <> 1 THEN "t2"."position" END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT("t2"."driverstandingsid"), 0) FROM "races" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."surname" = 'Hamilton' AND "t1"."year" >= 2010	select ((cast(count( case when "t2"."position" <> 1 then "t2"."position" end ) as float) * 100) / count("t2"."driverstandingsid")) from "races" "t1" join "driverstandings" "t2" on "t2"."raceid" = "t1"."raceid" join "drivers" "t3" on "t3"."driverid" = "t2"."driverid" where ( "t3"."surname" = 'Hamilton' and "t1"."year" >= 2010 )	SELECT CAST( COUNT( CASE WHEN "t2"."position" <> 1 THEN "t2"."position" END ) AS BINARY_DOUBLE ) * 100 / COUNT( "t2"."driverstandingsid" ) FROM "races" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."surname" = 'Hamilton' AND "t1"."year" >= 2010 ;	SELECT CAST( COUNT( CASE WHEN `t2`.`position` <> 1 THEN `t2`.`position` END ) AS NUMBER ) * 100 / COUNT( `t2`.`driverstandingsid` ) FROM `races` AS `t1` INNER JOIN `driverstandings` AS `t2` ON `t2`.`raceid` = `t1`.`raceid` INNER JOIN `drivers` AS `t3` ON `t3`.`driverid` = `t2`.`driverid` WHERE `t3`.`surname` = 'Hamilton' AND `t1`.`year` >= 2010	SELECT CAST( COUNT( CASE WHEN "t2"."position" <> 1 THEN 1 END ) AS NUMBER ) * 100 / COUNT( "t2"."driverstandingsid" ) FROM "races" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."surname" = 'Hamilton' AND "t1"."year" >= 2010
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( COUNT( CASE WHEN `t1`.`country` = 'Germany' THEN `t2`.`circuitid` END ) AS DOUBLE ) * 100 / COUNT( `t2`.`circuitid` ) FROM `circuits` AS `t1` INNER JOIN `races` AS `t2` ON `t2`.`circuitid` = `t1`.`circuitid` WHERE `t2`.`name` = 'European Grand Prix'	SELECT CAST(COUNT(CASE WHEN "t1"."country" = 'Germany' THEN "t2"."circuitid" END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT("t2"."circuitid"), 0) FROM "circuits" "t1" INNER JOIN "races" "t2" ON "t2"."circuitid" = "t1"."circuitid" WHERE "t2"."name" = 'European Grand Prix'	select ((cast(count( case when "t1"."country" = 'Germany' then "t2"."circuitid" end ) as float) * 100) / count("t2"."circuitid")) from "circuits" "t1" join "races" "t2" on "t2"."circuitid" = "t1"."circuitid" where "t2"."name" = 'European Grand Prix'	SELECT CAST( COUNT( CASE WHEN "t1"."country" = 'Germany' THEN "t2"."circuitid" END ) AS BINARY_DOUBLE ) * 100 / COUNT( "t2"."circuitid" ) FROM "circuits" "t1" INNER JOIN "races" "t2" ON "t2"."circuitid" = "t1"."circuitid" WHERE "t2"."name" = 'European Grand Prix' ;	SELECT CAST( COUNT( CASE WHEN t1.country = 'Germany' THEN t2.circuitid END ) AS NUMBER ) * 100 / COUNT( t2.circuitid ) FROM circuits AS t1 INNER JOIN races AS t2 ON t2.circuitid = t1.circuitid WHERE t2.name = 'European Grand Prix'	SELECT CAST( COUNT( CASE WHEN "t1"."country" = 'Germany' THEN "t2"."circuitid" END ) AS NUMBER ) * 100 / COUNT( "t2"."circuitid" ) FROM "circuits" "t1" INNER JOIN "races" "t2" ON "t2"."circuitid" = "t1"."circuitid" WHERE "t2"."name" = 'European Grand Prix'
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( `t3`.`dob` AS DATETIME ) , '%Y' ) < '1985' AND `t1`.`laps` > 50 THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( * ) FROM `results` AS `t1` INNER JOIN `races` AS `t2` ON `t1`.`raceid` = `t2`.`raceid` INNER JOIN `drivers` AS `t3` ON `t1`.`driverid` = `t3`.`driverid` WHERE `t2`.`year` BETWEEN 2000 AND 2005	SELECT CAST(SUM(CASE WHEN TO_CHAR(CAST("t3"."dob" AS DATETIME), 'YYYY') < '1985' AND "t1"."laps" > 50 THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT(*), 0) FROM "results" "t1" INNER JOIN "races" "t2" ON "t1"."raceid" = "t2"."raceid" INNER JOIN "drivers" "t3" ON "t1"."driverid" = "t3"."driverid" WHERE "t2"."year" BETWEEN 2000 AND 2005	select ((cast(sum( case when ( DATE_FORMAT( cast("t3"."dob" as timestamp), '%Y' ) < '1985' and "t1"."laps" > 50 ) then 1 else 0 end ) as float) * 100) / count(*)) from "results" "t1" join "races" "t2" on "t1"."raceid" = "t2"."raceid" join "drivers" "t3" on "t1"."driverid" = "t3"."driverid" where "t2"."year" between 2000 and 2005	SELECT CAST( SUM( CASE WHEN TO_CHAR( CAST( "t3"."dob" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) < '1985' AND "t1"."laps" > 50 THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) * 100 / COUNT( * ) FROM "results" "t1" INNER JOIN "races" "t2" ON "t1"."raceid" = "t2"."raceid" INNER JOIN "drivers" "t3" ON "t1"."driverid" = "t3"."driverid" WHERE "t2"."year" BETWEEN 2000 AND 2005 ;	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( `t3`.`dob` AS DATE ) ) < 1985 AND `t1`.`laps` > 50 THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( * ) FROM `results` AS `t1` INNER JOIN `races` AS `t2` ON `t1`.`raceid` = `t2`.`raceid` INNER JOIN `drivers` AS `t3` ON `t1`.`driverid` = `t3`.`driverid` WHERE `t2`.`year` BETWEEN 2000 AND 2005	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "t3"."dob" AS DATE ) ) < 1985 AND "t1"."laps" > 50 THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( * ) FROM "results" "t1" INNER JOIN "races" "t2" ON "t1"."raceid" = "t2"."raceid" INNER JOIN "drivers" "t3" ON "t1"."driverid" = "t3"."driverid" WHERE "t2"."year" BETWEEN 2000 AND 2005
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( COUNT( CASE WHEN `t3`.`colour` = 'Blue' THEN `t1`.`id` ELSE NULL END ) AS DOUBLE ) * 100 / COUNT( `t1`.`id` ) FROM `superhero` AS `t1` INNER JOIN `gender` AS `t2` ON `t1`.`gender_id` = `t2`.`id` INNER JOIN `colour` AS `t3` ON `t1`.`skin_colour_id` = `t3`.`id` WHERE `t2`.`gender` = 'Female'	SELECT CAST(COUNT(CASE WHEN "t3"."colour" = 'Blue' THEN "t1"."id" ELSE NULL END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT("t1"."id"), 0) FROM "superhero" "t1" INNER JOIN "gender" "t2" ON "t1"."gender_id" = "t2"."id" INNER JOIN "colour" "t3" ON "t1"."skin_colour_id" = "t3"."id" WHERE "t2"."gender" = 'Female'	select ((cast(count( case when "t3"."colour" = 'Blue' then "t1"."id" else null end ) as float) * 100) / count("t1"."id")) from "superhero" "t1" join "gender" "t2" on "t1"."gender_id" = "t2"."id" join "colour" "t3" on "t1"."skin_colour_id" = "t3"."id" where "t2"."gender" = 'Female'	SELECT CAST( COUNT( CASE WHEN "t3"."colour" = 'Blue' THEN "t1"."id" ELSE NULL END ) AS BINARY_DOUBLE ) * 100 / COUNT( "t1"."id" ) FROM "superhero" "t1" INNER JOIN "gender" "t2" ON "t1"."gender_id" = "t2"."id" INNER JOIN "colour" "t3" ON "t1"."skin_colour_id" = "t3"."id" WHERE "t2"."gender" = 'Female' ;	SELECT CAST( COUNT( CASE WHEN `t3`.`colour` = 'Blue' THEN `t1`.`id` ELSE NULL END ) AS NUMBER ) * 100 / COUNT( `t1`.`id` ) FROM `superhero` AS `t1` INNER JOIN `gender` AS `t2` ON `t1`.`gender_id` = `t2`.`id` INNER JOIN `colour` AS `t3` ON `t1`.`skin_colour_id` = `t3`.`id` WHERE `t2`.`gender` = 'Female'	SELECT CAST( COUNT( CASE WHEN "t3"."colour" = 'Blue' THEN "t1"."id" ELSE NULL END ) AS NUMBER ) * 100 / COUNT( "t1"."id" ) FROM "superhero" "t1" INNER JOIN "gender" "t2" ON "t1"."gender_id" = "t2"."id" INNER JOIN "colour" "t3" ON "t1"."skin_colour_id" = "t3"."id" WHERE "t2"."gender" = 'Female'
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( `creationdate` AS DATETIME ) , '%Y' ) = '2010' THEN 1 ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN DATE_FORMAT( CAST( `creationdate` AS DATETIME ) , '%Y' ) = '2011' THEN 1 ELSE 0 END ) FROM `votes`	SELECT CAST(SUM(CASE WHEN TO_CHAR(CAST("creationdate" AS DATETIME), 'YYYY') = '2010' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN TO_CHAR(CAST("creationdate" AS DATETIME), 'YYYY') = '2011' THEN 1 ELSE 0 END), 0) FROM "votes"	select (cast(sum( case when DATE_FORMAT( cast("creationdate" as timestamp), '%Y' ) = '2010' then 1 else 0 end ) as float) / sum( case when DATE_FORMAT( cast("creationdate" as timestamp), '%Y' ) = '2011' then 1 else 0 end )) from "votes"	SELECT CAST( SUM( CASE WHEN TO_CHAR( CAST( "creationdate" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) = '2010' THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) / SUM( CASE WHEN TO_CHAR( CAST( "creationdate" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) = '2011' THEN 1 ELSE 0 END ) FROM "votes" ;	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM TO_DATE( `creationdate`, 'YYYY-MM-DD' ) ) = 2010 THEN 1 ELSE 0 END ) AS NUMBER ) / SUM( CASE WHEN EXTRACT(YEAR FROM TO_DATE( `creationdate`, 'YYYY-MM-DD' ) ) = 2011 THEN 1 ELSE 0 END ) FROM `votes`	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "creationdate" AS DATE ) ) = 2010 THEN 1 ELSE 0 END ) AS NUMBER ) / SUM( CASE WHEN TO_CHAR( CAST( "creationdate" AS TIMESTAMP ), 'YYYY' ) = '2011' THEN 1 ELSE 0 END ) FROM "votes"
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-01476: divisor is equal to zero Help: https://docs.oracle.com/error-help/db/ora-01476/	√
SELECT CAST( SUM( CASE WHEN NOT `t1`.`cardkingdomfoilid` IS NULL AND NOT `t1`.`cardkingdomid` IS NULL THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `t1`.`id` ) FROM `cards` AS `t1` INNER JOIN `sets` AS `t2` ON `t2`.`code` = `t1`.`setcode` WHERE `t2`.`name` = 'Coldsnap'	SELECT CAST(SUM(CASE WHEN NOT "t1"."cardkingdomfoilid" IS NULL AND NOT "t1"."cardkingdomid" IS NULL THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT("t1"."id"), 0) FROM "cards" "t1" INNER JOIN "sets" "t2" ON "t2"."code" = "t1"."setcode" WHERE "t2"."name" = 'Coldsnap'	select ((cast(sum( case when ( not ("t1"."cardkingdomfoilid" is null) and not ("t1"."cardkingdomid" is null) ) then 1 else 0 end ) as float) * 100) / count("t1"."id")) from "cards" "t1" join "sets" "t2" on "t2"."code" = "t1"."setcode" where "t2"."name" = 'Coldsnap'	SELECT CAST( SUM( CASE WHEN NOT "t1"."cardkingdomfoilid" IS NULL AND NOT "t1"."cardkingdomid" IS NULL THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) * 100 / COUNT( "t1"."id" ) FROM "cards" "t1" INNER JOIN "sets" "t2" ON "t2"."code" = "t1"."setcode" WHERE "t2"."name" = 'Coldsnap' ;	SELECT CAST( SUM( CASE WHEN NOT `t1`.`cardkingdomfoilid` IS NULL AND NOT `t1`.`cardkingdomid` IS NULL THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( `t1`.`id` ) FROM `cards` `t1` JOIN `sets` `t2` ON `t2`.`code` = `t1`.`setcode` WHERE `t2`.`name` = 'Coldsnap'	SELECT CAST( SUM( CASE WHEN NOT "t1"."cardkingdomfoilid" IS NULL AND NOT "t1"."cardkingdomid" IS NULL THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( "t1"."id" ) FROM "cards" "t1" INNER JOIN "sets" "t2" ON "t2"."code" = "t1"."setcode" WHERE "t2"."name" = 'Coldsnap'
Source Dialect	√	√	√	√	√
SELECT CAST( COUNT( DISTINCT CASE WHEN `t1`.`element` = 'c' THEN `t1`.`atom_id` ELSE NULL END ) AS DOUBLE ) * 100 / COUNT( DISTINCT `t1`.`atom_id` ) FROM `atom` AS `t1` INNER JOIN `bond` AS `t2` ON `t1`.`molecule_id` = `t2`.`molecule_id` WHERE `t2`.`bond_type` = '='	SELECT CAST(COUNT(DISTINCT CASE WHEN "t1"."element" = 'c' THEN "t1"."atom_id" ELSE NULL END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT(DISTINCT "t1"."atom_id"), 0) FROM "atom" "t1" INNER JOIN "bond" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."bond_type" = '='	select ((cast(count(distinct case when "t1"."element" = 'c' then "t1"."atom_id" else null end ) as float) * 100) / count(distinct "t1"."atom_id")) from "atom" "t1" join "bond" "t2" on "t1"."molecule_id" = "t2"."molecule_id" where "t2"."bond_type" = '='	SELECT CAST( COUNT( DISTINCT CASE WHEN "t1"."element" = 'c' THEN "t1"."atom_id" ELSE NULL END ) AS BINARY_DOUBLE ) * 100 / COUNT( DISTINCT "t1"."atom_id" ) FROM "atom" "t1" INNER JOIN "bond" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."bond_type" = '=' ;	SELECT CAST( COUNT( DISTINCT CASE WHEN t1.element = 'c' THEN t1.atom_id ELSE NULL END ) AS NUMBER ) * 100 / COUNT( DISTINCT t1.atom_id ) FROM atom AS t1 JOIN bond AS t2 ON t1.molecule_id = t2.molecule_id WHERE t2.bond_type = '='	SELECT CAST( COUNT( DISTINCT CASE WHEN "t1"."element" = 'c' THEN "t1"."atom_id" ELSE NULL END ) AS NUMBER ) * 100 / COUNT( DISTINCT "t1"."atom_id" ) FROM "atom" "t1" INNER JOIN "bond" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."bond_type" = '='
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( COUNT( DISTINCT CASE WHEN `t1`.`element` <> 'f' THEN `t2`.`molecule_id` ELSE NULL END ) AS DOUBLE ) * 100 / COUNT( DISTINCT `t2`.`molecule_id` ) FROM `atom` AS `t1` INNER JOIN `molecule` AS `t2` ON `t1`.`molecule_id` = `t2`.`molecule_id` WHERE `t2`.`label` = '+'	SELECT CAST(COUNT(DISTINCT CASE WHEN "t1"."element" <> 'f' THEN "t2"."molecule_id" ELSE NULL END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT(DISTINCT "t2"."molecule_id"), 0) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '+'	select ((cast(count(distinct case when "t1"."element" <> 'f' then "t2"."molecule_id" else null end ) as float) * 100) / count(distinct "t2"."molecule_id")) from "atom" "t1" join "molecule" "t2" on "t1"."molecule_id" = "t2"."molecule_id" where "t2"."label" = '+'	SELECT CAST( COUNT( DISTINCT CASE WHEN "t1"."element" <> 'f' THEN "t2"."molecule_id" ELSE NULL END ) AS BINARY_DOUBLE ) * 100 / COUNT( DISTINCT "t2"."molecule_id" ) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '+' ;	SELECT CAST( COUNT( DISTINCT CASE WHEN `t1`.`element` <> 'f' THEN `t2`.`molecule_id` ELSE NULL END ) AS NUMBER ) * 100 / COUNT( DISTINCT `t2`.`molecule_id` ) FROM `atom` AS `t1` INNER JOIN `molecule` AS `t2` ON `t1`.`molecule_id` = `t2`.`molecule_id` WHERE `t2`.`label` = '+'	SELECT CAST( COUNT( DISTINCT CASE WHEN "t1"."element" <> 'f' THEN "t2"."molecule_id" ELSE NULL END ) AS NUMBER ) * 100 / COUNT( DISTINCT "t2"."molecule_id" ) FROM "atom" "t1" RIGHT JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '+'
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( COUNT( DISTINCT CASE WHEN `t2`.`label` = '+' THEN `t2`.`molecule_id` ELSE NULL END ) AS DOUBLE ) * 100 / COUNT( DISTINCT `t2`.`molecule_id` ) FROM `atom` AS `t1` INNER JOIN `molecule` AS `t2` ON `t1`.`molecule_id` = `t2`.`molecule_id` INNER JOIN `bond` AS `t3` ON `t2`.`molecule_id` = `t3`.`molecule_id` WHERE `t3`.`bond_type` = '#'	SELECT CAST(COUNT(DISTINCT CASE WHEN "t2"."label" = '+' THEN "t2"."molecule_id" ELSE NULL END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT(DISTINCT "t2"."molecule_id"), 0) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" INNER JOIN "bond" "t3" ON "t2"."molecule_id" = "t3"."molecule_id" WHERE "t3"."bond_type" = '#'	select ((cast(count(distinct case when "t2"."label" = '+' then "t2"."molecule_id" else null end ) as float) * 100) / count(distinct "t2"."molecule_id")) from "atom" "t1" join "molecule" "t2" on "t1"."molecule_id" = "t2"."molecule_id" join "bond" "t3" on "t2"."molecule_id" = "t3"."molecule_id" where "t3"."bond_type" = '#'	SELECT CAST( COUNT( DISTINCT CASE WHEN "t2"."label" = '+' THEN "t2"."molecule_id" ELSE NULL END ) AS BINARY_DOUBLE ) * 100 / COUNT( DISTINCT "t2"."molecule_id" ) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" INNER JOIN "bond" "t3" ON "t2"."molecule_id" = "t3"."molecule_id" WHERE "t3"."bond_type" = '#' ;	SELECT CAST( COUNT( DISTINCT CASE WHEN `t2`.`label` = '+' THEN `t2`.`molecule_id` ELSE NULL END ) AS NUMBER ) * 100 / COUNT( DISTINCT `t2`.`molecule_id` ) FROM `atom` AS `t1` INNER JOIN `molecule` AS `t2` ON `t1`.`molecule_id` = `t2`.`molecule_id` INNER JOIN `bond` AS `t3` ON `t2`.`molecule_id` = `t3`.`molecule_id` WHERE `t3`.`bond_type` = '#'	SELECT CAST( COUNT( DISTINCT CASE WHEN "t2"."label" = '+' THEN "t2"."molecule_id" ELSE NULL END ) AS NUMBER ) * 100 / COUNT( DISTINCT "t2"."molecule_id" ) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" INNER JOIN "bond" "t3" ON "t2"."molecule_id" = "t3"."molecule_id" WHERE "t3"."bond_type" = '#'
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( COUNT( `t2`.`bond_id` ) AS DOUBLE ) / COUNT( `t1`.`atom_id` ) FROM `atom` AS `t1` INNER JOIN `connected` AS `t2` ON `t1`.`atom_id` = `t2`.`atom_id` WHERE `t1`.`element` = 'i'	SELECT CAST(COUNT("t2"."bond_id") AS DOUBLE PRECISION) / NULLIF(COUNT("t1"."atom_id"), 0) FROM "atom" "t1" INNER JOIN "connected" "t2" ON "t1"."atom_id" = "t2"."atom_id" WHERE "t1"."element" = 'i'	select (cast(count("t2"."bond_id") as float) / count("t1"."atom_id")) from "atom" "t1" join "connected" "t2" on "t1"."atom_id" = "t2"."atom_id" where "t1"."element" = 'i'	SELECT CAST( COUNT( "t2"."bond_id" ) AS BINARY_DOUBLE ) / COUNT( "t1"."atom_id" ) FROM "atom" "t1" INNER JOIN "connected" "t2" ON "t1"."atom_id" = "t2"."atom_id" WHERE "t1"."element" = 'i' ;	SELECT CAST( COUNT( t2.bond_id ) AS NUMBER ) / COUNT( t1.atom_id ) FROM atom AS t1 INNER JOIN connected AS t2 ON t1.atom_id = t2.atom_id WHERE t1.element = 'i'	SELECT CAST( COUNT( "t2"."bond_id" ) AS NUMBER ) / COUNT( "t1"."atom_id" ) FROM "atom" "t1" INNER JOIN "connected" "t2" ON "t1"."atom_id" = "t2"."atom_id" WHERE "t1"."element" = 'i'
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( SUM( CASE WHEN `doc` = 54 THEN 1 ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN `doc` = 52 THEN 1 ELSE 0 END ) FROM `schools` WHERE `statustype` = 'Merged' AND `county` = 'Orange'	SELECT CAST(SUM(CASE WHEN "doc" = 54 THEN 1 ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN "doc" = 52 THEN 1 ELSE 0 END), 0) FROM "schools" WHERE "statustype" = 'Merged' AND "county" = 'Orange'	select (cast(sum( case when "doc" = 54 then 1 else 0 end ) as float) / sum( case when "doc" = 52 then 1 else 0 end )) from "schools" where ( "statustype" = 'Merged' and "county" = 'Orange' )	SELECT CAST( SUM( CASE WHEN "doc" = 54 THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) / SUM( CASE WHEN "doc" = 52 THEN 1 ELSE 0 END ) FROM "schools" WHERE "statustype" = 'Merged' AND "county" = 'Orange' ;	SELECT CAST( SUM( CASE WHEN `doc` = 54 THEN 1 ELSE 0 END ) AS NUMBER ) / SUM( CASE WHEN `doc` = 52 THEN 1 ELSE 0 END ) FROM `schools` WHERE `statustype` = 'Merged' AND `county` = 'Orange'	SELECT CAST( SUM( CASE WHEN "doc" = 54 THEN 1 ELSE 0 END ) AS NUMBER ) / SUM( CASE WHEN "doc" = 52 THEN 1 ELSE 0 END ) FROM "schools" WHERE "statustype" = 'Merged' AND "county" = 'Orange'
Source Dialect	√	√	√	√	√
SELECT COUNT( `t2`.`client_id` ) FROM `district` AS `t1` INNER JOIN `client` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` WHERE `t2`.`gender` = 'F' AND DATE_FORMAT( CAST( `t2`.`birth_date` AS DATETIME ) , '%Y' ) < '1950' AND `t1`.`a2` = 'Sokolov'	SELECT COUNT("t2"."client_id") FROM "district" "t1" INNER JOIN "client" "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t2"."gender" = 'F' AND TO_CHAR(CAST("t2"."birth_date" AS DATETIME), 'YYYY') < '1950' AND "t1"."a2" = 'Sokolov'	select count("t2"."client_id") from "district" "t1" join "client" "t2" on "t1"."district_id" = "t2"."district_id" where ( "t2"."gender" = 'F' and DATE_FORMAT( cast("t2"."birth_date" as timestamp), '%Y' ) < '1950' and "t1"."a2" = 'Sokolov' )	SELECT COUNT( "t2"."client_id" ) FROM "district" "t1" INNER JOIN "client" "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t2"."gender" = 'F' AND TO_CHAR( CAST( "t2"."birth_date" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) < '1950' AND "t1"."a2" = 'Sokolov' ;	SELECT COUNT( t2.client_id ) FROM district AS t1 INNER JOIN client AS t2 ON t1.district_id = t2.district_id WHERE t2.gender = 'F' AND TRUNC( t2.birth_date ) < TO_DATE( '1950-01-01', 'YYYY-MM-DD' ) AND t1.a2 = 'Sokolov'	SELECT COUNT( "t2"."client_id" ) FROM "district" "t1" INNER JOIN "client" "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t2"."gender" = 'F' AND TO_CHAR( CAST( "t2"."birth_date" AS TIMESTAMP ), 'YYYY' ) < '1950' AND "t1"."a2" = 'Sokolov'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( ( SUM( CASE WHEN DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) = '1997' THEN `t1`.`amount` ELSE 0 END ) - SUM( CASE WHEN DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) = '1996' THEN `t1`.`amount` ELSE 0 END ) ) AS DOUBLE ) * 100 / SUM( CASE WHEN DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) = '1996' THEN `t1`.`amount` ELSE 0 END ) FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` INNER JOIN `disp` AS `t3` ON `t3`.`account_id` = `t2`.`account_id` INNER JOIN `client` AS `t4` ON `t4`.`client_id` = `t3`.`client_id` WHERE `t4`.`gender` = 'M' AND `t3`.`type` = 'OWNER'	SELECT CAST((SUM(CASE WHEN TO_CHAR(CAST("t1"."date" AS DATETIME), 'YYYY') = '1997' THEN "t1"."amount" ELSE 0 END) - SUM(CASE WHEN TO_CHAR(CAST("t1"."date" AS DATETIME), 'YYYY') = '1996' THEN "t1"."amount" ELSE 0 END)) AS DOUBLE PRECISION) * 100 / NULLIF(SUM(CASE WHEN TO_CHAR(CAST("t1"."date" AS DATETIME), 'YYYY') = '1996' THEN "t1"."amount" ELSE 0 END), 0) FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "disp" "t3" ON "t3"."account_id" = "t2"."account_id" INNER JOIN "client" "t4" ON "t4"."client_id" = "t3"."client_id" WHERE "t4"."gender" = 'M' AND "t3"."type" = 'OWNER'	select ((cast((sum( case when DATE_FORMAT( cast("t1"."date" as timestamp), '%Y' ) = '1997' then "t1"."amount" else 0 end ) - sum( case when DATE_FORMAT( cast("t1"."date" as timestamp), '%Y' ) = '1996' then "t1"."amount" else 0 end )) as float) * 100) / sum( case when DATE_FORMAT( cast("t1"."date" as timestamp), '%Y' ) = '1996' then "t1"."amount" else 0 end )) from "loan" "t1" join "account" "t2" on "t1"."account_id" = "t2"."account_id" join "disp" "t3" on "t3"."account_id" = "t2"."account_id" join "client" "t4" on "t4"."client_id" = "t3"."client_id" where ( "t4"."gender" = 'M' and "t3"."type" = 'OWNER' )	SELECT CAST( ( SUM( CASE WHEN TO_CHAR( CAST( t1.date AS TIMESTAMP(0) ) , 'YYYY' ) = '1997' THEN t1.amount ELSE 0 END ) - SUM( CASE WHEN TO_CHAR( CAST( t1.date AS TIMESTAMP(0) ) , 'YYYY' ) = '1996' THEN t1.amount ELSE 0 END ) ) AS BINARY_DOUBLE ) * 100 / SUM( CASE WHEN TO_CHAR( CAST( t1.date AS TIMESTAMP(0) ) , 'YYYY' ) = '1996' THEN t1.amount ELSE 0 END ) FROM loan t1 INNER JOIN account t2 ON t1.account_id = t2.account_id INNER JOIN disp t3 ON t3.account_id = t2.account_id INNER JOIN client t4 ON t4.client_id = t3.client_id WHERE t4.gender = 'M' AND t3.type = 'OWNER'	SELECT CAST( ( SUM( CASE WHEN EXTRACT(YEAR FROM `t1`.`date`) = 1997 THEN `t1`.`amount` ELSE 0 END ) - SUM( CASE WHEN EXTRACT(YEAR FROM `t1`.`date`) = 1996 THEN `t1`.`amount` ELSE 0 END ) ) AS NUMBER ) * 100 / SUM( CASE WHEN EXTRACT(YEAR FROM `t1`.`date`) = 1996 THEN `t1`.`amount` ELSE 0 END ) FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` INNER JOIN `disp` AS `t3` ON `t3`.`account_id` = `t2`.`account_id` INNER JOIN `client` AS `t4` ON `t4`.`client_id` = `t3`.`client_id` WHERE `t4`.`gender` = 'M' AND `t3`.`type` = 'OWNER'	SELECT CAST( ( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "t1"."date" AS DATE ) ) = 1997 THEN "t1"."amount" ELSE 0 END ) - SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "t1"."date" AS DATE ) ) = 1996 THEN "t1"."amount" ELSE 0 END ) ) AS NUMBER ) * 100 / SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "t1"."date" AS DATE ) ) = 1996 THEN "t1"."amount" ELSE 0 END ) FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "disp" "t3" ON "t3"."account_id" = "t2"."account_id" INNER JOIN "client" "t4" ON "t4"."client_id" = "t3"."client_id" WHERE "t4"."gender" = 'M' AND "t3"."type" = 'OWNER'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-01747: invalid user.table.column, table.column, or column specification Help: https://docs.oracle.com/error-help/db/ora-01747/	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( SUM( CASE WHEN `currency` = 'EUR' THEN 1 ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN `currency` = 'CZK' THEN 1 ELSE 0 END ) FROM `customers`	SELECT CAST(SUM(CASE WHEN "currency" = 'EUR' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN "currency" = 'CZK' THEN 1 ELSE 0 END), 0) FROM "customers"	select (cast(sum( case when "currency" = 'EUR' then 1 else 0 end ) as float) / sum( case when "currency" = 'CZK' then 1 else 0 end )) from "customers"	SELECT CAST( SUM( CASE WHEN "currency" = 'EUR' THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) / SUM( CASE WHEN "currency" = 'CZK' THEN 1 ELSE 0 END ) FROM "customers" ;	SELECT CAST(SUM(CASE WHEN `currency` = 'EUR' THEN 1 ELSE 0 END) AS NUMBER) / SUM(CASE WHEN `currency` = 'CZK' THEN 1 ELSE 0 END) FROM `customers`	SELECT CAST(SUM(CASE WHEN "currency" = 'EUR' THEN 1 ELSE 0 END) AS NUMBER) / SUM( CASE WHEN "currency" = 'CZK' THEN 1 ELSE 0 END ) FROM "customers"
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( CASE WHEN `consumption` > 528.3 THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `customerid` ) FROM `yearmonth` WHERE `date` = '201202'	SELECT CAST(SUM(CASE WHEN "consumption" > 528.3 THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT("customerid"), 0) FROM "yearmonth" WHERE "date" = '201202'	select ((cast(sum( case when "consumption" > 528.3 then 1 else 0 end ) as float) * 100) / count("customerid")) from "yearmonth" where "date" = '201202'	SELECT CAST( SUM( CASE WHEN "consumption" > 528.3 THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) * 100 / COUNT( "customerid" ) FROM "yearmonth" WHERE "date" = '201202' ;	SELECT CAST( SUM( CASE WHEN `consumption` > 528.3 THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( `customerid` ) FROM `yearmonth` WHERE `date` = TO_DATE('201202', 'YYYYMM')	SELECT CAST(SUM(CASE WHEN "consumption" > 528.3 THEN 1 ELSE 0 END) AS NUMBER) * 100 / COUNT( "customerid" ) FROM "yearmonth" WHERE "date" = '201202'
Source Dialect	√	√	√	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	√
SELECT COUNT( `t1`.`transactionid` ) FROM `transactions_1k` AS `t1` INNER JOIN `gasstations` AS `t2` ON `t1`.`gasstationid` = `t2`.`gasstationid` WHERE `t2`.`country` = 'CZE' AND DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) >= '2012'	SELECT COUNT("t1"."transactionid") FROM "transactions_1k" "t1" INNER JOIN "gasstations" "t2" ON "t1"."gasstationid" = "t2"."gasstationid" WHERE "t2"."country" = 'CZE' AND TO_CHAR(CAST("t1"."date" AS DATETIME), 'YYYY') >= '2012'	select count("t1"."transactionid") from "transactions_1k" "t1" join "gasstations" "t2" on "t1"."gasstationid" = "t2"."gasstationid" where ( "t2"."country" = 'CZE' and DATE_FORMAT( cast("t1"."date" as timestamp), '%Y' ) >= '2012' )	SELECT COUNT( t1.transactionid ) FROM transactions_1k t1 INNER JOIN gasstations t2 ON t1.gasstationid = t2.gasstationid WHERE t2.country = 'CZE' AND TO_CHAR( CAST( t1.date AS TIMESTAMP(0) ) , 'YYYY' ) >= '2012'	SELECT COUNT( t1.transactionid ) FROM transactions_1k AS t1 INNER JOIN gasstations AS t2 ON t1.gasstationid = t2.gasstationid WHERE t2.country = 'CZE' AND TO_CHAR( TRUNC( t1.date, 'YYYY' ) ) >= '2012'	SELECT COUNT( "t1"."transactionid" ) FROM "transactions_1k" "t1" INNER JOIN "gasstations" "t2" ON "t1"."gasstationid" = "t2"."gasstationid" WHERE "t2"."country" = 'CZE' AND TO_CHAR( CAST( "t1"."date" AS TIMESTAMP ), 'RRRR' ) >= '2012'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-01747: invalid user.table.column, table.column, or column specification Help: https://docs.oracle.com/error-help/db/ora-01747/	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( SUM( CASE WHEN SUBSTR( `date` , 1 , 4 ) = '2012' THEN `consumption` ELSE 0 END ) - SUM( CASE WHEN SUBSTR( `date` , 1 , 4 ) = '2013' THEN `consumption` ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN SUBSTR( `date` , 1 , 4 ) = '2012' THEN `consumption` ELSE 0 END ) FROM `yearmonth` WHERE `customerid` = ( SELECT `t1`.`customerid` FROM `transactions_1k` AS `t1` INNER JOIN `gasstations` AS `t2` ON `t1`.`gasstationid` = `t2`.`gasstationid` WHERE `t1`.`date` = '2012-08-25' AND `t1`.`price` = 1513.12 )	SELECT CAST(SUM(CASE WHEN SUBSTR("date", 1, 4) = '2012' THEN "consumption" ELSE 0 END) - SUM(CASE WHEN SUBSTR("date", 1, 4) = '2013' THEN "consumption" ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN SUBSTR("date", 1, 4) = '2012' THEN "consumption" ELSE 0 END), 0) FROM "yearmonth" WHERE "customerid" = (SELECT "t1"."customerid" FROM "transactions_1k" "t1" INNER JOIN "gasstations" "t2" ON "t1"."gasstationid" = "t2"."gasstationid" WHERE "t1"."date" = '2012-08-25' AND "t1"."price" = 1513.12)	select (cast((sum( case when substr("date", 1, 4) = '2012' then "consumption" else 0 end ) - sum( case when substr("date", 1, 4) = '2013' then "consumption" else 0 end )) as float) / sum( case when substr("date", 1, 4) = '2012' then "consumption" else 0 end )) from "yearmonth" where "customerid" = ( select "t1"."customerid" from "transactions_1k" "t1" join "gasstations" "t2" on "t1"."gasstationid" = "t2"."gasstationid" where ( "t1"."date" = '2012-08-25' and "t1"."price" = 1513.12 ) )	SELECT CAST( SUM( CASE WHEN SUBSTR( "date" , 1 , 4 ) = '2012' THEN consumption ELSE 0 END ) - SUM( CASE WHEN SUBSTR( "date" , 1 , 4 ) = '2013' THEN consumption ELSE 0 END ) AS BINARY_DOUBLE ) / SUM( CASE WHEN SUBSTR( "date" , 1 , 4 ) = '2012' THEN consumption ELSE 0 END ) FROM yearmonth WHERE customerid = ( SELECT t1.customerid FROM transactions_1k t1 INNER JOIN gasstations t2 ON t1.gasstationid = t2.gasstationid WHERE t1.date = '2012-08-25' AND t1.price = 1513.12 )	SELECT CAST( SUM( CASE WHEN SUBSTR( `date`, 1, 4 ) = '2012' THEN `consumption` ELSE 0 END ) - SUM( CASE WHEN SUBSTR( `date`, 1, 4 ) = '2013' THEN `consumption` ELSE 0 END ) AS NUMBER ) / SUM( CASE WHEN SUBSTR( `date`, 1, 4 ) = '2012' THEN `consumption` ELSE 0 END ) FROM `yearmonth` WHERE `customerid` = ( SELECT `t1`.`customerid` FROM `transactions_1k` AS `t1` JOIN `gasstations` AS `t2` ON `t1`.`gasstationid` = `t2`.`gasstationid` WHERE `t1`.`date` = '2012-08-25' AND `t1`.`price` = 1513.12 )	SELECT CAST( SUM( CASE WHEN TO_CHAR( "date", 'YYYY' ) = '2012' THEN "consumption" ELSE 0 END ) - SUM( CASE WHEN TO_CHAR( "date", 'YYYY' ) = '2013' THEN "consumption" ELSE 0 END ) AS NUMBER ) / SUM( CASE WHEN SUBSTR( "date" , 1 , 4 ) = '2012' THEN "consumption" ELSE 0 END ) FROM "yearmonth" WHERE "customerid" = ( SELECT "t1"."customerid" FROM "transactions_1k" "t1" INNER JOIN "gasstations" "t2" ON "t1"."gasstationid" = "t2"."gasstationid" WHERE "t1"."date" = '2012-08-25' AND "t1"."price" = 1513.12 )
Source Dialect	√	√	ORA-01747: invalid user.table.column, table.column, or column specification Help: https://docs.oracle.com/error-help/db/ora-01747/	ORA-00907: missing right parenthesis Help: https://docs.oracle.com/error-help/db/ora-00907/	√
SELECT CAST( SUM( CASE WHEN `t2`.`event_name` = 'Yearly Kickoff' THEN `t1`.`amount` ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN `t2`.`event_name` = 'October Meeting' THEN `t1`.`amount` ELSE 0 END ) FROM `budget` AS `t1` INNER JOIN `event` AS `t2` ON `t1`.`link_to_event` = `t2`.`event_id` WHERE `t1`.`category` = 'Advertisement' AND `t2`.`type` = 'Meeting'	SELECT CAST(SUM(CASE WHEN "t2"."event_name" = 'Yearly Kickoff' THEN "t1"."amount" ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN "t2"."event_name" = 'October Meeting' THEN "t1"."amount" ELSE 0 END), 0) FROM "budget" "t1" INNER JOIN "event" "t2" ON "t1"."link_to_event" = "t2"."event_id" WHERE "t1"."category" = 'Advertisement' AND "t2"."type" = 'Meeting'	select (cast(sum( case when "t2"."event_name" = 'Yearly Kickoff' then "t1"."amount" else 0 end ) as float) / sum( case when "t2"."event_name" = 'October Meeting' then "t1"."amount" else 0 end )) from "budget" "t1" join "event" "t2" on "t1"."link_to_event" = "t2"."event_id" where ( "t1"."category" = 'Advertisement' and "t2"."type" = 'Meeting' )	SELECT CAST( SUM( CASE WHEN "t2"."event_name" = 'Yearly Kickoff' THEN "t1"."amount" ELSE 0 END ) AS BINARY_DOUBLE ) / SUM( CASE WHEN "t2"."event_name" = 'October Meeting' THEN "t1"."amount" ELSE 0 END ) FROM "budget" "t1" INNER JOIN "event" "t2" ON "t1"."link_to_event" = "t2"."event_id" WHERE "t1"."category" = 'Advertisement' AND "t2"."type" = 'Meeting' ;	SELECT CAST( SUM( CASE WHEN t2.event_name = 'Yearly Kickoff' THEN t1.amount ELSE 0 END ) AS NUMBER ) / SUM( CASE WHEN t2.event_name = 'October Meeting' THEN t1.amount ELSE 0 END ) FROM budget AS t1 JOIN event AS t2 ON t1.link_to_event = t2.event_id WHERE t1.category = 'Advertisement' AND t2.type = 'Meeting'	SELECT CAST(SUM(CASE WHEN "t2"."event_name" = 'Yearly Kickoff' THEN "t1"."amount" ELSE 0 END) AS NUMBER) / SUM(CASE WHEN "t2"."event_name" = 'October Meeting' THEN "t1"."amount" ELSE 0 END) FROM "budget" "t1" INNER JOIN "event" "t2" ON "t1"."link_to_event" = "t2"."event_id" WHERE "t1"."category" = 'Advertisement' AND "t2"."type" = 'Meeting'
Source Dialect	√	√	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT CAST( SUM( CASE WHEN `admission` = '+' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / SUM( CASE WHEN `admission` = '-' THEN 1 ELSE 0 END ) FROM `patient` WHERE `sex` = 'M'	SELECT CAST(SUM(CASE WHEN "admission" = '+' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 / NULLIF(SUM(CASE WHEN "admission" = '-' THEN 1 ELSE 0 END), 0) FROM "patient" WHERE "sex" = 'M'	select ((cast(sum( case when "admission" = '+' then 1 else 0 end ) as float) * 100) / sum( case when "admission" = '-' then 1 else 0 end )) from "patient" where "sex" = 'M'	SELECT CAST( SUM( CASE WHEN "admission" = '+' THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) * 100 / SUM( CASE WHEN "admission" = '-' THEN 1 ELSE 0 END ) FROM "patient" WHERE "sex" = 'M' ;	SELECT CAST( SUM( CASE WHEN `admission` = '+' THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / SUM( CASE WHEN `admission` = '-' THEN 1 ELSE 0 END ) FROM `patient` WHERE `sex` = 'M'	SELECT CAST(SUM(CASE WHEN "admission" = '+' THEN 1 ELSE 0 END) AS NUMBER) * 100 / SUM( CASE WHEN "admission" = '-' THEN 1 ELSE 0 END ) FROM "patient" WHERE "sex" = 'M'
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( `birthday` AS DATETIME ) , '%Y' ) > '1930' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( * ) FROM `patient` WHERE `sex` = 'F'	SELECT CAST(SUM(CASE WHEN TO_CHAR(CAST("birthday" AS DATETIME), 'YYYY') > '1930' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 / NULLIF(COUNT(*), 0) FROM "patient" WHERE "sex" = 'F'	select ((cast(sum( case when DATE_FORMAT( cast("birthday" as timestamp), '%Y' ) > '1930' then 1 else 0 end ) as float) * 100) / count(*)) from "patient" where "sex" = 'F'	SELECT CAST( SUM( CASE WHEN TO_CHAR( CAST( "birthday" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) > '1930' THEN 1 ELSE 0 END ) AS BINARY_DOUBLE ) * 100 / COUNT( * ) FROM "patient" WHERE "sex" = 'F' ;	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM TO_DATE( `birthday`, 'YYYY-MM-DD' ) ) > 1930 THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( * ) FROM `patient` WHERE `sex` = 'F'	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "birthday" AS DATE ) ) > 1930 THEN 1 ELSE 0 END ) AS NUMBER ) * 100 / COUNT( * ) FROM "patient" WHERE "sex" = 'F'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-01858: a non-numeric character was found where a numeric was expected Help: https://docs.oracle.com/error-help/db/ora-01858/	√
SELECT COUNT( * ) FROM `patient` WHERE DATE_FORMAT( CAST( `description` AS DATETIME ) , '%Y' ) = '1997' AND `sex` = 'F' AND `admission` = '-'	SELECT COUNT(*) FROM "patient" WHERE TO_CHAR(CAST("description" AS DATETIME), 'YYYY') = '1997' AND "sex" = 'F' AND "admission" = '-'	select count(*) from "patient" where ( DATE_FORMAT( cast("description" as timestamp), '%Y' ) = '1997' and "sex" = 'F' and "admission" = '-' )	SELECT COUNT( * ) FROM "patient" WHERE TO_CHAR( CAST( "description" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) = '1997' AND "sex" = 'F' AND "admission" = '-' ;	SELECT COUNT(*) FROM `patient` WHERE EXTRACT(YEAR FROM TO_DATE(`description`, 'YYYY-MM-DD')) = 1997 AND `sex` = 'F' AND `admission` = '-'	SELECT COUNT( * ) FROM "patient" WHERE TO_CHAR(CAST("description" AS TIMESTAMP), 'YYYY') = '1997' AND "sex" = 'F' AND "admission" = '-'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-01858: a non-numeric character was found where a numeric was expected Help: https://docs.oracle.com/error-help/db/ora-01858/	√
SELECT COUNT( `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `examination` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE DATE_FORMAT( CAST( `t2`.`examination date` AS DATETIME ) , '%Y' ) BETWEEN '1990' AND '1993' AND DATE_FORMAT( CAST( `t2`.`examination date` AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) < '18'	SELECT COUNT("t1"."id") FROM "patient" "t1" INNER JOIN "examination" "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR(CAST("t2"."examination date" AS DATETIME), 'YYYY') BETWEEN '1990' AND '1993' AND TO_CHAR(CAST("t2"."examination date" AS DATETIME), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS DATETIME), 'YYYY') < '18'	select count("t1"."id") from "patient" "t1" join "examination" "t2" on "t1"."id" = "t2"."id" where ( DATE_FORMAT( cast("t2"."examination date" as timestamp), '%Y' ) between '1990' and '1993' and (DATE_FORMAT( cast("t2"."examination date" as timestamp), '%Y' ) - DATE_FORMAT( cast("t1"."birthday" as timestamp), '%Y' )) < '18' )	SELECT COUNT( t1.id ) FROM patient t1 INNER JOIN examination t2 ON t1.id = t2.id WHERE DATE_FORMAT( CAST( t2.examination "date" "AS" DATETIME ) , '%Y' ) BETWEEN '1990' AND '1993' AND DATE_FORMAT( CAST( t2.examination date AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( t1.birthday AS TIMESTAMP(0) ) , '%Y' ) < '18'	SELECT COUNT( t1.id ) FROM patient AS t1 INNER JOIN examination AS t2 ON t1.id = t2.id WHERE TO_CHAR( TRUNC( TO_DATE( t2."examination date", 'DD/MM/YYYY' ), 'YYYY' ) ) BETWEEN '1990' AND '1993' AND TO_CHAR( TRUNC( TO_DATE( t2."examination date", 'DD/MM/YYYY' ), 'YYYY' ) ) - TO_CHAR( TRUNC( TO_DATE( t1."birthday", 'DD/MM/YYYY' ), 'YYYY' ) ) < 18	SELECT COUNT( "t1"."id" ) FROM "patient" "t1" INNER JOIN "examination" "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR( TRUNC( "t2"."examination date" ), 'YYYY' ) BETWEEN '1990' AND '1993' AND TO_CHAR( TRUNC( "t2"."examination date" ), 'YYYY' ) - TO_CHAR( TRUNC( "t1"."birthday" ), 'YYYY' ) < '18'
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-00905: missing keyword Help: https://docs.oracle.com/error-help/db/ora-00905/	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT COUNT( DISTINCT `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`tg` >= 200 AND DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) > 50	SELECT COUNT(DISTINCT "t1"."id") FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."tg" >= 200 AND TO_CHAR(CAST(CURRENT_TIMESTAMP AS DATETIME), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS DATETIME), 'YYYY') > 50	select count(distinct "t1"."id") from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where ( "t2"."tg" >= 200 and (DATE_FORMAT( cast(current_timestamp as timestamp), '%Y' ) - DATE_FORMAT( cast("t1"."birthday" as timestamp), '%Y' )) > 50 )	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."tg" >= 200 AND TO_CHAR( CAST( "CURRENT_TIMESTAMP" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) - TO_CHAR( CAST( "t1"."birthday" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) > 50	SELECT COUNT(DISTINCT t1.id) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.tg >= 200 AND EXTRACT(YEAR FROM SYSTIMESTAMP) - EXTRACT(YEAR FROM TO_DATE(t1.birthday, 'YYYY-MM-DD')) > 50	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."tg" >= 200 AND EXTRACT(YEAR FROM SYSTIMESTAMP) - EXTRACT(YEAR FROM "t1"."birthday") > 50
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-00904: "CURRENT_TIMESTAMP": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT COUNT( DISTINCT `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) BETWEEN '1936' AND '1956' AND `t1`.`sex` = 'M' AND `t2`.`cpk` >= 250	SELECT COUNT(DISTINCT "t1"."id") FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR(CAST("t1"."birthday" AS DATETIME), 'YYYY') BETWEEN '1936' AND '1956' AND "t1"."sex" = 'M' AND "t2"."cpk" >= 250	select count(distinct "t1"."id") from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where ( DATE_FORMAT( cast("t1"."birthday" as timestamp), '%Y' ) between '1936' and '1956' and "t1"."sex" = 'M' and "t2"."cpk" >= 250 )	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR( CAST( "t1"."birthday" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) BETWEEN '1936' AND '1956' AND "t1"."sex" = 'M' AND "t2"."cpk" >= 250 ;	SELECT COUNT(DISTINCT t1.id) FROM patient AS t1 JOIN laboratory AS t2 ON t1.id = t2.id WHERE TO_CHAR(TRUNC(TO_DATE(t1.birthday, 'YYYY-MM-DD')), 'YYYY') BETWEEN '1936' AND '1956' AND t1.sex = 'M' AND t2.cpk >= 250	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE EXTRACT(YEAR FROM CAST("t1"."birthday" AS DATE)) BETWEEN 1936 AND 1956 AND "t1"."sex" = 'M' AND "t2"."cpk" >= 250
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT COUNT( DISTINCT `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`cre` >= 1.5 AND YEAR( CURDATE( ) ) - YEAR( `t1`.`birthday` ) < 70	SELECT COUNT(DISTINCT "t1"."id") FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."cre" >= 1.5 AND YEAR(CAST(CURDATE() AS DATE)) - YEAR(CAST("t1"."birthday" AS DATE)) < 70	select count(distinct "t1"."id") from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where ( "t2"."cre" >= 1.5 and (extract(year from trunc(current_date)) - extract(year from "t1"."birthday")) < 70 )	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."cre" >= 1.5 AND EXTRACT( YEAR FROM TRUNC( SYSDATE ) ) - EXTRACT( YEAR FROM "t1"."birthday" ) < 70 ;	SELECT COUNT( DISTINCT t2.id ) FROM patient t1 INNER JOIN laboratory t2 ON t1.id = t2.id WHERE t2.cre >= 1.5 AND EXTRACT(YEAR FROM SYSTIMESTAMP) - EXTRACT(YEAR FROM t1.birthday) < 70	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."cre" >= 1.5 AND EXTRACT(YEAR FROM SYSTIMESTAMP) - EXTRACT(YEAR FROM "t1"."birthday") < 70
Source Dialect	ORA-00904: "YEAR": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	√	ORA-00942: table or view does not exist Help: https://docs.oracle.com/error-help/db/ora-00942/	√
SELECT `name` FROM `races` WHERE DATE_FORMAT( CAST( `date` AS DATETIME ) , '%Y' ) = ( SELECT DATE_FORMAT( CAST( `date` AS DATETIME ) , '%Y' ) FROM `races` ORDER BY `date` ASC LIMIT 1 ) AND DATE_FORMAT( CAST( `date` AS DATETIME ) , '%m' ) = ( SELECT DATE_FORMAT( CAST( `date` AS DATETIME ) , '%m' ) FROM `races` ORDER BY `date` ASC LIMIT 1 )	SELECT "name" FROM "races" WHERE TO_CHAR(CAST("date" AS DATETIME), 'YYYY') = (SELECT TO_CHAR(CAST("date" AS DATETIME), 'YYYY') FROM "races" ORDER BY "date" ASC NULLS FIRST FETCH FIRST 1 ROWS ONLY) AND TO_CHAR(CAST("date" AS DATETIME), 'MM') = (SELECT TO_CHAR(CAST("date" AS DATETIME), 'MM') FROM "races" ORDER BY "date" ASC NULLS FIRST FETCH FIRST 1 ROWS ONLY)	select "name" from "races" where ( DATE_FORMAT( cast("date" as timestamp), '%Y' ) = ( select "v0" DATE_FORMAT from ( select "x"."v0", rownum "rn" from ( select DATE_FORMAT( cast("date" as timestamp), '%Y' ) "v0" from "races" order by "date" asc ) "x" where rownum <= 1 ) where "rn" > 0 ) and DATE_FORMAT( cast("date" as timestamp), '%m' ) = ( select "v0" DATE_FORMAT from ( select "x"."v0", rownum "rn" from ( select DATE_FORMAT( cast("date" as timestamp), '%m' ) "v0" from "races" order by "date" asc ) "x" where rownum <= 1 ) where "rn" > 0 ) )	SELECT "name" FROM "races" WHERE TO_CHAR( CAST( "date" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) = ( SELECT TO_CHAR( CAST( "date" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) FROM "races" ORDER BY "date" ASC FETCH NEXT 1 ROWS ONLY ) AND TO_CHAR( CAST( "date" AS TIMESTAMP ( 0 ) ) , 'MM' ) = ( SELECT TO_CHAR( CAST( "date" AS TIMESTAMP ( 0 ) ) , 'MM' ) FROM "races" ORDER BY "date" ASC FETCH NEXT 1 ROWS ONLY )	SELECT `name` FROM `races` WHERE EXTRACT(YEAR FROM `date`) = (SELECT EXTRACT(YEAR FROM `date`) FROM `races` ORDER BY `date` ASC FETCH FIRST 1 ROW ONLY) AND EXTRACT(MONTH FROM `date`) = (SELECT EXTRACT(MONTH FROM `date`) FROM `races` ORDER BY `date` ASC FETCH FIRST 1 ROW ONLY)	SELECT "name" FROM "races" WHERE EXTRACT(YEAR FROM "date") = (SELECT EXTRACT(YEAR FROM MIN("date")) FROM "races") AND EXTRACT(MONTH FROM "date") = (SELECT EXTRACT(MONTH FROM MIN("date")) FROM "races")
Source Dialect	ORA-00907: missing right parenthesis Help: https://docs.oracle.com/error-help/db/ora-00907/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	ORA-00907: missing right parenthesis Help: https://docs.oracle.com/error-help/db/ora-00907/	ORA-00907: missing right parenthesis Help: https://docs.oracle.com/error-help/db/ora-00907/	√
SELECT COUNT( `id` ) FROM `users` WHERE DATE( `lastaccessdate` ) > '2014-09-01'	SELECT COUNT("id") FROM "users" WHERE CAST("lastaccessdate" AS DATE) > '2014-09-01'	select count("id") from "users" where cast("lastaccessdate" as date) > '2014-09-01'	SELECT COUNT( "id" ) FROM "users" WHERE TO_DATE( lastaccessdate ) > '2014-09-01'	SELECT COUNT( `id` ) FROM `users` WHERE TRUNC( `lastaccessdate` ) > TO_DATE( '2014-09-01', 'YYYY-MM-DD' )	SELECT COUNT( "id" ) FROM "users" WHERE TO_DATE( "lastaccessdate" ) > TO_DATE('2014-09-01', 'YYYY-MM-DD')
Source Dialect	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-00904: "LASTACCESSDATE": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	√
SELECT COUNT( `t2`.`school` ) FROM `frpm` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cdscode` = `t2`.`cdscode` WHERE `t2`.`county` = 'Los Angeles' AND `t2`.`charter` = 0 AND CAST( `t1`.`free meal count (k-12)` AS DOUBLE ) * 100 / `t1`.`enrollment (k-12)` < 0.18	SELECT COUNT("t2"."school") FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'Los Angeles' AND "t2"."charter" = 0 AND CAST("t1"."free meal count (k-12)" AS DOUBLE PRECISION) * 100 / NULLIF("t1"."enrollment (k-12)", 0) < 0.18	select count("t2"."school") from "frpm" "t1" join "schools" "t2" on "t1"."cdscode" = "t2"."cdscode" where ( "t2"."county" = 'Los Angeles' and "t2"."charter" = 0 and ((cast("t1"."free meal count (k-12)" as float) * 100) / "t1"."enrollment (k-12)") < 0.18 )	SELECT COUNT( t2.school ) FROM frpm t1 INNER JOIN schools t2 ON t1.cdscode = t2.cdscode WHERE t2.county = 'Los Angeles' AND t2.charter = 0 AND CAST( t1.free meal count (k-12) AS DOUBLE ) * 100 / t1.enrollment (k-12) < 0.18	SELECT COUNT( t2.school ) FROM frpm AS t1 INNER JOIN schools AS t2 ON t1.cdscode = t2.cdscode WHERE t2.county = 'Los Angeles' AND t2.charter = 0 AND ( t1."free meal count (k-12)" / t1."enrollment (k-12)" ) * 100 < 0.18	SELECT COUNT( "t2"."school" ) FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'Los Angeles' AND "t2"."charter" = 0 AND CAST( "t1"."free meal count (k-12)" AS NUMBER ) * 100 / "t1"."enrollment (k-12)" < 0.18
Source Dialect	√	√	ORA-00905: missing keyword Help: https://docs.oracle.com/error-help/db/ora-00905/	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√
SELECT `t2`.`admemail1` , `t2`.`admemail2` FROM `frpm` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cdscode` = `t2`.`cdscode` WHERE `t2`.`county` = 'San Bernardino' AND `t2`.`city` = 'San Bernardino' AND `t2`.`doc` = 54 AND DATE_FORMAT( CAST( `t2`.`opendate` AS DATETIME ) , '%Y' ) BETWEEN '2009' AND '2010' AND `t2`.`soc` = 62	SELECT "t2"."admemail1", "t2"."admemail2" FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'San Bernardino' AND "t2"."city" = 'San Bernardino' AND "t2"."doc" = 54 AND TO_CHAR(CAST("t2"."opendate" AS DATETIME), 'YYYY') BETWEEN '2009' AND '2010' AND "t2"."soc" = 62	select "t2"."admemail1", "t2"."admemail2" from "frpm" "t1" join "schools" "t2" on "t1"."cdscode" = "t2"."cdscode" where ( "t2"."county" = 'San Bernardino' and "t2"."city" = 'San Bernardino' and "t2"."doc" = 54 and DATE_FORMAT( cast("t2"."opendate" as timestamp), '%Y' ) between '2009' and '2010' and "t2"."soc" = 62 )	SELECT "t2"."admemail1" , "t2"."admemail2" FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'San Bernardino' AND "t2"."city" = 'San Bernardino' AND "t2"."doc" = 54 AND TO_CHAR( CAST( "t2"."opendate" AS TIMESTAMP ( 0 ) ) , 'YYYY' ) BETWEEN '2009' AND '2010' AND "t2"."soc" = 62 ;	SELECT t2.admemail1, t2.admemail2 FROM frpm AS t1 INNER JOIN schools AS t2 ON t1.cdscode = t2.cdscode WHERE t2.county = 'San Bernardino' AND t2.city = 'San Bernardino' AND t2.doc = 54 AND TO_CHAR(TRUNC(t2.opendate, 'YYYY')) BETWEEN '2009' AND '2010' AND t2.soc = 62	SELECT "t2"."admemail1" , "t2"."admemail2" FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'San Bernardino' AND "t2"."city" = 'San Bernardino' AND "t2"."doc" = 54 AND EXTRACT(YEAR FROM "t2"."opendate") BETWEEN 2009 AND 2010 AND "t2"."soc" = 62
Source Dialect	ORA-00902: invalid datatype Help: https://docs.oracle.com/error-help/db/ora-00902/	ORA-00904: "DATE_FORMAT": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-00933: SQL command not properly ended Help: https://docs.oracle.com/error-help/db/ora-00933/	√

MySQL	SQLGlot	jOOQ	SQLines	GPT-4o	CrackSQL
SELECT CAST( COUNT( `t1`.`id` ) AS DOUBLE ) / 12 FROM `postlinks` AS `t1` INNER JOIN `posts` AS `t2` ON `t1`.`postid` = `t2`.`id` WHERE `t2`.`answercount` <= 2 AND DATE_FORMAT( CAST( `t1`.`creationdate` AS DATETIME ) , '%Y' ) = '2010'	SELECT CAST(COUNT("t1"."id") AS DOUBLE PRECISION) / NULLIF(12, 0) FROM "postlinks" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."postid" = "t2"."id" WHERE "t2"."answercount" <= 2 AND TO_CHAR(CAST("t1"."creationdate" AS TIMESTAMP), 'YYYY') = '2010'		SELECT CAST( COUNT( "t1"."id" ) AS DOUBLE PRECISION ) / 12 FROM "postlinks" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."postid" = "t2"."id" WHERE "t2"."answercount" <= 2 AND DATE_FORMAT( CAST( "t1"."creationdate" AS TIMESTAMP ( 0 ) ) , '' ) = '2010'	SELECT CAST(COUNT(t1.id) AS DOUBLE PRECISION) / 12 FROM postlinks AS t1 INNER JOIN posts AS t2 ON t1.postid = t2.id WHERE t2.answercount <= 2 AND EXTRACT(YEAR FROM t1.creationdate) = 2010;	SELECT CAST( COUNT( "t1"."id" ) AS DOUBLE PRECISION ) / 12 FROM "postlinks" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."postid" = "t2"."id" WHERE "t2"."answercount" <= 2 AND EXTRACT(YEAR FROM CAST( "t1"."creationdate" AS TIMESTAMP )) = '2010'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ...id" = "t2"."id" WHERE "t2"."answercount" <= 2 AND DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT DISTINCT `t1`.`id` , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) FROM `patient` AS `t1` INNER JOIN `examination` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`rvvt` = '+'	SELECT DISTINCT "t1"."id", TO_CHAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."rvvt" = '+'		SELECT DISTINCT t1.id , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(0) ) , '' ) - DATE_FORMAT( CAST( t1.birthday AS TIMESTAMP(0) ) , '' ) FROM patient AS t1 INNER JOIN examination AS t2 ON t1.id = t2.id WHERE t2.rvvt = '+'	SELECT DISTINCT t1.id, EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM t1.birthday) FROM patient AS t1 INNER JOIN examination AS t2 ON t1.id = t2.id WHERE t2.rvvt = '+'	SELECT DISTINCT "t1"."id" , EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM CAST( "t1"."birthday" AS TIMESTAMP )) FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."rvvt" = '+'
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near ")" LINE 1: ...NCT t1.id , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMES... ^	√	√
SELECT CAST( SUM( CASE WHEN `t2`.`ua` <= 8.0 AND `t1`.`sex` = 'M' THEN 1 ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN `t2`.`ua` <= 6.5 AND `t1`.`sex` = 'F' THEN 1 ELSE 0 END ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id`	SELECT CAST(SUM(CASE WHEN "t2"."ua" <= 8.0 AND "t1"."sex" = 'M' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN "t2"."ua" <= 6.5 AND "t1"."sex" = 'F' THEN 1 ELSE 0 END), 0) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id"	select (cast(sum(case when ( "t2"."ua" <= 8.0 and "t1"."sex" = 'M' ) then 1 else 0 end) as double precision) / sum(case when ( "t2"."ua" <= 6.5 and "t1"."sex" = 'F' ) then 1 else 0 end)) from "patient" as "t1" join "laboratory" as "t2" on "t1"."id" = "t2"."id"	SELECT CAST( SUM( CASE WHEN "t2"."ua" <= 8.0 AND "t1"."sex" = 'M' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) / SUM( CASE WHEN "t2"."ua" <= 6.5 AND "t1"."sex" = 'F' THEN 1 ELSE 0 END ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" ;	SELECT CAST( SUM( CASE WHEN `t2`.`ua` <= 8.0 AND `t1`.`sex` = 'M' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) / SUM( CASE WHEN `t2`.`ua` <= 6.5 AND `t1`.`sex` = 'F' THEN 1 ELSE 0 END ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id`;	SELECT CAST( SUM( CASE WHEN "t2"."ua" <= 8.0 AND "t1"."sex" = 'M' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) / SUM( CASE WHEN "t2"."ua" <= 6.5 AND "t1"."sex" = 'F' THEN 1 ELSE 0 END ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id"
Source Dialect	√	√	√	syntax error at or near "." LINE 1: SELECT CAST( SUM( CASE WHEN `t2`.`ua` <= 8.0 AND `t1`.`sex` ... ^	√
SELECT CAST( SUM( CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `id` ) FROM `patient` WHERE `diagnosis` = 'RA' AND DATE_FORMAT( CAST( `birthday` AS DATETIME ) , '%Y' ) = '1980'	SELECT CAST(CAST(SUM(CASE WHEN "sex" = 'F' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("id"), 0) FROM "patient" WHERE "diagnosis" = 'RA' AND TO_CHAR(CAST("birthday" AS TIMESTAMP), 'YYYY') = '1980'		SELECT CAST( SUM( CASE WHEN "sex" = 'F' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) FROM "patient" WHERE "diagnosis" = 'RA' AND DATE_FORMAT( CAST( "birthday" AS TIMESTAMP ( 0 ) ) , '' ) = '1980'	SELECT CAST(SUM(CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100.0 / COUNT(`id`) FROM `patient` WHERE `diagnosis` = 'RA' AND EXTRACT(YEAR FROM `birthday`) = 1980;	SELECT CAST( SUM( CASE WHEN "sex" = 'F' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) FROM "patient" WHERE "diagnosis" = 'RA' AND EXTRACT(YEAR FROM CAST( "birthday" AS TIMESTAMP )) = '1980'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ...id" ) FROM "patient" WHERE "diagnosis" = 'RA' AND DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	syntax error at or near "=" LINE 1: SELECT CAST(SUM(CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END) AS ... ^	√
SELECT CAST( SUM( CASE WHEN `t2`.`pt` >= 14 AND `t1`.`sex` = 'F' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( CASE WHEN `t2`.`pt` >= 14 THEN 1 ELSE 0 END ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) > 55	SELECT CAST(CAST(SUM(CASE WHEN "t2"."pt" >= 14 AND "t1"."sex" = 'F' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT(CASE WHEN "t2"."pt" >= 14 THEN 1 ELSE 0 END), 0) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') > 55		SELECT CAST( SUM( CASE WHEN t2.pt >= 14 AND t1.sex = 'F' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( CASE WHEN t2.pt >= 14 THEN 1 ELSE 0 END ) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE CAST(DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(0) ) , '' ) - DATE_FORMAT( CAST( t1.birthday AS TIMESTAMP(0) ) , '' ) AS INT) > 55	Answer not returned in the given format!	SELECT CAST( SUM( CASE WHEN "t2"."pt" >= 14 AND "t1"."sex" = 'F' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( CASE WHEN "t2"."pt" >= 14 THEN 1 ELSE 0 END ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM CAST( "t1"."birthday" AS TIMESTAMP )) > 55
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near ")" LINE 1: ... WHERE CAST(DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMES... ^	syntax error at or near "Answer" LINE 1: Answer not returned in the given format! ^	√
SELECT CAST( SUM( `t2`.`long_shots` ) AS DOUBLE ) / COUNT( `t2`.`date` ) FROM `player` AS `t1` INNER JOIN `player_attributes` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE `t1`.`player_name` = 'Ahmed Samir Farag'	SELECT CAST(SUM("t2"."long_shots") AS DOUBLE PRECISION) / NULLIF(COUNT("t2"."date"), 0) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Ahmed Samir Farag'	select (cast(sum("t2"."long_shots") as double precision) / count("t2"."date")) from "player" as "t1" join "player_attributes" as "t2" on "t1"."player_api_id" = "t2"."player_api_id" where "t1"."player_name" = 'Ahmed Samir Farag'	SELECT CAST( SUM( "t2"."long_shots" ) AS DOUBLE PRECISION ) / COUNT( "t2"."date" ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Ahmed Samir Farag' ;	SELECT CAST( SUM( t2.long_shots ) AS DOUBLE PRECISION ) / COUNT( t2.date ) FROM player AS t1 INNER JOIN player_attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE t1.player_name = 'Ahmed Samir Farag'	SELECT CAST( SUM( "t2"."long_shots" ) AS DOUBLE PRECISION ) / COUNT( "t2"."date" ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Ahmed Samir Farag'
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( CASE WHEN `t1`.`player_name` = 'Abdou Diallo' THEN `t2`.`ball_control` ELSE 0 END ) AS DOUBLE ) / COUNT( CASE WHEN `t1`.`player_name` = 'Abdou Diallo' THEN `t2`.`id` ELSE NULL END ) - CAST( SUM( CASE WHEN `t1`.`player_name` = 'Aaron Appindangoye' THEN `t2`.`ball_control` ELSE 0 END ) AS DOUBLE ) / COUNT( CASE WHEN `t1`.`player_name` = 'Aaron Appindangoye' THEN `t2`.`id` ELSE NULL END ) FROM `player` AS `t1` INNER JOIN `player_attributes` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id`	SELECT CAST(SUM(CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(COUNT(CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END), 0) - CAST(SUM(CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(COUNT(CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END), 0) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id"	select ((cast(sum(case when "t1"."player_name" = 'Abdou Diallo' then "t2"."ball_control" else 0 end) as double precision) / count(case when "t1"."player_name" = 'Abdou Diallo' then "t2"."id" else null end)) - (cast(sum(case when "t1"."player_name" = 'Aaron Appindangoye' then "t2"."ball_control" else 0 end) as double precision) / count(case when "t1"."player_name" = 'Aaron Appindangoye' then "t2"."id" else null end))) from "player" as "t1" join "player_attributes" as "t2" on "t1"."player_api_id" = "t2"."player_api_id"	SELECT CAST( SUM( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END ) AS DOUBLE PRECISION ) / COUNT( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END ) - CAST( SUM( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END ) AS DOUBLE PRECISION ) / COUNT( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" ;	SELECT CAST( SUM( CASE WHEN t1.player_name = 'Abdou Diallo' THEN t2.ball_control ELSE 0 END ) AS DOUBLE PRECISION ) / COUNT( CASE WHEN t1.player_name = 'Abdou Diallo' THEN t2.id ELSE NULL END ) - CAST( SUM( CASE WHEN t1.player_name = 'Aaron Appindangoye' THEN t2.ball_control ELSE 0 END ) AS DOUBLE PRECISION ) / COUNT( CASE WHEN t1.player_name = 'Aaron Appindangoye' THEN t2.id ELSE NULL END ) FROM player AS t1 INNER JOIN player_attributes AS t2 ON t1.player_api_id = t2.player_api_id;	SELECT CAST( SUM( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END ) AS DOUBLE PRECISION ) / COUNT( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END ) - CAST( SUM( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END ) AS DOUBLE PRECISION) / COUNT( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id"
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( `t2`.`overall_rating` ) AS DOUBLE ) / COUNT( `t2`.`id` ) FROM `player` AS `t1` INNER JOIN `player_attributes` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE `t1`.`player_name` = 'Pietro Marino'	SELECT CAST(SUM("t2"."overall_rating") AS DOUBLE PRECISION) / NULLIF(COUNT("t2"."id"), 0) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Pietro Marino'	select (cast(sum("t2"."overall_rating") as double precision) / count("t2"."id")) from "player" as "t1" join "player_attributes" as "t2" on "t1"."player_api_id" = "t2"."player_api_id" where "t1"."player_name" = 'Pietro Marino'	SELECT CAST( SUM( "t2"."overall_rating" ) AS DOUBLE PRECISION ) / COUNT( "t2"."id" ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Pietro Marino' ;	SELECT CAST( SUM( t2."overall_rating" ) AS DOUBLE PRECISION ) / COUNT( t2."id" ) FROM player AS t1 INNER JOIN player_attributes AS t2 ON t1."player_api_id" = t2."player_api_id" WHERE t1."player_name" = 'Pietro Marino';	SELECT CAST( SUM( t2."overall_rating" ) AS DOUBLE PRECISION ) / COUNT( t2."id" ) FROM "player" AS t1 INNER JOIN "player_attributes" AS t2 ON t1."player_api_id" = t2."player_api_id" WHERE t1."player_name" = 'Pietro Marino'
Source Dialect	√	√	√	√	√
SELECT CAST( COUNT( CASE WHEN NOT `t2`.`time` IS NULL THEN `t2`.`driverid` END ) AS DOUBLE ) * 100 / COUNT( `t2`.`driverid` ) FROM `races` AS `t1` INNER JOIN `results` AS `t2` ON `t2`.`raceid` = `t1`.`raceid` WHERE `t1`.`date` = '1983-07-16'	SELECT CAST(CAST(COUNT(CASE WHEN NOT "t2"."time" IS NULL THEN "t2"."driverid" END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("t2"."driverid"), 0) FROM "races" AS "t1" INNER JOIN "results" AS "t2" ON "t2"."raceid" = "t1"."raceid" WHERE "t1"."date" = '1983-07-16'	select ((cast(count(case when not ("t2"."time" is null) then "t2"."driverid" end) as double precision) * 100) / count("t2"."driverid")) from "races" as "t1" join "results" as "t2" on "t2"."raceid" = "t1"."raceid" where "t1"."date" = '1983-07-16'	SELECT CAST( COUNT( CASE WHEN NOT "t2"."time" IS NULL THEN "t2"."driverid" END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t2"."driverid" ) FROM "races" AS "t1" INNER JOIN "results" AS "t2" ON "t2"."raceid" = "t1"."raceid" WHERE "t1"."date" = '1983-07-16' ;	SELECT CAST(COUNT(CASE WHEN NOT t2."time" IS NULL THEN t2."driverid" END) AS DOUBLE PRECISION) * 100 / COUNT(t2."driverid") FROM races AS t1 INNER JOIN results AS t2 ON t2."raceid" = t1."raceid" WHERE t1."date" = '1983-07-16';	SELECT CAST(COUNT(CASE WHEN "t2"."time" IS NOT NULL THEN "t2"."driverid" END) AS DOUBLE PRECISION) * 100.0 / COUNT("t2"."driverid") FROM "races" AS "t1" INNER JOIN "results" AS "t2" ON "t2"."raceid" = "t1"."raceid" WHERE "t1"."date" = '1983-07-16';
Source Dialect	√	√	√	√	√
SELECT DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `dob` AS DATETIME ) , '%Y' ) , `forename` , `surname` FROM `drivers` WHERE `nationality` = 'Japanese' ORDER BY `dob` DESC LIMIT 1	SELECT TO_CHAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("dob" AS TIMESTAMP), 'YYYY'), "forename", "surname" FROM "drivers" WHERE "nationality" = 'Japanese' ORDER BY "dob" DESC NULLS LAST LIMIT 1		SELECT DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(0) ) , '' ) - DATE_FORMAT( CAST( dob AS TIMESTAMP(0) ) , '' ) , forename , surname FROM drivers WHERE nationality = 'Japanese' ORDER BY dob DESC LIMIT 1	SELECT EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM `dob`), `forename`, `surname` FROM `drivers` WHERE `nationality` = 'Japanese' ORDER BY `dob` DESC LIMIT 1	SELECT EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM CAST( "dob" AS TIMESTAMP )) , "forename" , "surname" FROM "drivers" WHERE "nationality" = 'Japanese' ORDER BY "dob" DESC LIMIT 1
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near ")" LINE 1: SELECT DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(... ^	syntax error at or near ")" LINE 1: ... FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM `dob`), `forena... ^	√
SELECT `t2`.`driverid` , `t2`.`code` FROM `results` AS `t1` INNER JOIN `drivers` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` WHERE DATE_FORMAT( CAST( `t2`.`dob` AS DATETIME ) , '%Y' ) = '1971' AND NOT `t1`.`fastestlaptime` IS NULL	SELECT "t2"."driverid", "t2"."code" FROM "results" AS "t1" INNER JOIN "drivers" AS "t2" ON "t1"."driverid" = "t2"."driverid" WHERE TO_CHAR(CAST("t2"."dob" AS TIMESTAMP), 'YYYY') = '1971' AND NOT "t1"."fastestlaptime" IS NULL		SELECT "t2"."driverid" , "t2"."code" FROM "results" AS "t1" INNER JOIN "drivers" AS "t2" ON "t1"."driverid" = "t2"."driverid" WHERE DATE_FORMAT( CAST( "t2"."dob" AS TIMESTAMP ( 0 ) ) , '' ) = '1971' AND NOT "t1"."fastestlaptime" IS NULL	SELECT t2.driverid, t2.code FROM results AS t1 INNER JOIN drivers AS t2 ON t1.driverid = t2.driverid WHERE EXTRACT(YEAR FROM t2.dob) = 1971 AND t1.fastestlaptime IS NOT NULL;	SELECT "t2"."driverid" , "t2"."code" FROM "results" AS "t1" INNER JOIN "drivers" AS "t2" ON "t1"."driverid" = "t2"."driverid" WHERE EXTRACT(YEAR FROM CAST( "t2"."dob" AS TIMESTAMP )) = 1971 AND NOT "t1"."fastestlaptime" IS NULL
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ...S "t2" ON "t1"."driverid" = "t2"."driverid" WHERE DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	Inconsistent Result	√
SELECT ( CAST( COUNT( * ) AS DOUBLE ) * 100 / ( SELECT COUNT( * ) FROM `superhero` ) ) , CAST( SUM( CASE WHEN `t2`.`publisher_name` = 'Marvel Comics' THEN 1 ELSE 0 END ) AS DOUBLE ) FROM `superhero` AS `t1` INNER JOIN `publisher` AS `t2` ON `t1`.`publisher_id` = `t2`.`id` INNER JOIN `alignment` AS `t3` ON `t3`.`id` = `t1`.`alignment_id` WHERE `t3`.`alignment` = 'Bad'	SELECT (CAST(CAST(COUNT() AS DOUBLE PRECISION) 100 AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(*) FROM "superhero"), 0)), CAST(SUM(CASE WHEN "t2"."publisher_name" = 'Marvel Comics' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) FROM "superhero" AS "t1" INNER JOIN "publisher" AS "t2" ON "t1"."publisher_id" = "t2"."id" INNER JOIN "alignment" AS "t3" ON "t3"."id" = "t1"."alignment_id" WHERE "t3"."alignment" = 'Bad'	select ((cast(count() as double precision) 100) / ( select count(*) from "superhero" )), cast(sum(case when "t2"."publisher_name" = 'Marvel Comics' then 1 else 0 end) as double precision) from "superhero" as "t1" join "publisher" as "t2" on "t1"."publisher_id" = "t2"."id" join "alignment" as "t3" on "t3"."id" = "t1"."alignment_id" where "t3"."alignment" = 'Bad'	SELECT ( CAST( COUNT( * ) AS DOUBLE PRECISION ) * 100 / ( SELECT COUNT( * ) FROM "superhero" ) ) , CAST( SUM( CASE WHEN "t2"."publisher_name" = 'Marvel Comics' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) FROM "superhero" AS "t1" INNER JOIN "publisher" AS "t2" ON "t1"."publisher_id" = "t2"."id" INNER JOIN "alignment" AS "t3" ON "t3"."id" = "t1"."alignment_id" WHERE "t3"."alignment" = 'Bad' ;	SELECT ( CAST( COUNT( * ) AS DOUBLE PRECISION ) * 100 / ( SELECT COUNT( * ) FROM "superhero" ) ), CAST( SUM( CASE WHEN "t2"."publisher_name" = 'Marvel Comics' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) FROM "superhero" AS "t1" INNER JOIN "publisher" AS "t2" ON "t1"."publisher_id" = "t2"."id" INNER JOIN "alignment" AS "t3" ON "t3"."id" = "t1"."alignment_id" WHERE "t3"."alignment" = 'Bad'	SELECT ( CAST(COUNT() AS DOUBLE PRECISION) 100 / ( SELECT COUNT( * ) FROM "superhero" ) ) , CAST( SUM( CASE WHEN "t2"."publisher_name" = 'Marvel Comics' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) FROM "superhero" AS "t1" INNER JOIN "publisher" AS "t2" ON "t1"."publisher_id" = "t2"."id" INNER JOIN "alignment" AS "t3" ON "t3"."id" = "t1"."alignment_id" WHERE "t3"."alignment" = 'Bad'
Source Dialect	√	√	√	√	√
SELECT CAST( COUNT( CASE WHEN `t2`.`colour` = 'Blue' THEN 1 ELSE NULL END ) AS DOUBLE ) * 100 / COUNT( `t1`.`id` ) FROM `superhero` AS `t1` INNER JOIN `colour` AS `t2` ON `t1`.`eye_colour_id` = `t2`.`id`	SELECT CAST(CAST(COUNT(CASE WHEN "t2"."colour" = 'Blue' THEN 1 ELSE NULL END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("t1"."id"), 0) FROM "superhero" AS "t1" INNER JOIN "colour" AS "t2" ON "t1"."eye_colour_id" = "t2"."id"	select ((cast(count(case when "t2"."colour" = 'Blue' then 1 else null end) as double precision) * 100) / count("t1"."id")) from "superhero" as "t1" join "colour" as "t2" on "t1"."eye_colour_id" = "t2"."id"	SELECT CAST( COUNT( CASE WHEN "t2"."colour" = 'Blue' THEN 1 ELSE NULL END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."id" ) FROM "superhero" AS "t1" INNER JOIN "colour" AS "t2" ON "t1"."eye_colour_id" = "t2"."id" ;	SELECT CAST(COUNT(CASE WHEN t2.colour = 'Blue' THEN 1 ELSE NULL END) AS DOUBLE PRECISION) * 100 / COUNT(t1.id) FROM superhero AS t1 INNER JOIN colour AS t2 ON t1.eye_colour_id = t2.id	SELECT CAST( COUNT( CASE WHEN "t2"."colour" = 'Blue' THEN 1 ELSE NULL END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."id" ) FROM "superhero" AS "t1" INNER JOIN "colour" AS "t2" ON "t1"."eye_colour_id" = "t2"."id"
Source Dialect	√	√	√	√	√
SELECT CAST( COUNT( DISTINCT `t2`.`id` ) AS DOUBLE ) / COUNT( DISTINCT `t1`.`id` ) FROM `votes` AS `t1` INNER JOIN `posts` AS `t2` ON `t1`.`userid` = `t2`.`owneruserid` WHERE `t1`.`userid` = 24	SELECT CAST(COUNT(DISTINCT "t2"."id") AS DOUBLE PRECISION) / NULLIF(COUNT(DISTINCT "t1"."id"), 0) FROM "votes" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."userid" = "t2"."owneruserid" WHERE "t1"."userid" = 24	select (cast(count(distinct "t2"."id") as double precision) / count(distinct "t1"."id")) from "votes" as "t1" join "posts" as "t2" on "t1"."userid" = "t2"."owneruserid" where "t1"."userid" = 24	SELECT CAST( COUNT( DISTINCT "t2"."id" ) AS DOUBLE PRECISION ) / COUNT( DISTINCT "t1"."id" ) FROM "votes" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."userid" = "t2"."owneruserid" WHERE "t1"."userid" = 24 ;	SELECT CAST(COUNT(DISTINCT t2.id) AS DOUBLE PRECISION) / COUNT(DISTINCT t1.id) FROM votes AS t1 INNER JOIN posts AS t2 ON t1.userid = t2.owneruserid WHERE t1.userid = 24;	SELECT CAST( COUNT( DISTINCT "t2"."id" ) AS FLOAT8 ) / COUNT(DISTINCT "t1"."id") FROM "votes" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."userid" = "t2"."owneruserid" WHERE "t1"."userid" = 24
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( `date` AS DATETIME ) , '%Y' ) = '2010' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `id` ) - CAST( SUM( CASE WHEN DATE_FORMAT( CAST( `date` AS DATETIME ) , '%Y' ) = '2011' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `id` ) FROM `badges` WHERE `name` = 'Student'	SELECT CAST(CAST(SUM(CASE WHEN TO_CHAR(CAST("date" AS TIMESTAMP), 'YYYY') = '2010' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("id"), 0) - CAST(CAST(SUM(CASE WHEN TO_CHAR(CAST("date" AS TIMESTAMP), 'YYYY') = '2011' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("id"), 0) FROM "badges" WHERE "name" = 'Student'		SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( "date" AS TIMESTAMP ( 0 ) ) , '' ) = '2010' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) - CAST( SUM( CASE WHEN DATE_FORMAT( CAST( "date" AS TIMESTAMP ( 0 ) ) , '' ) = '2011' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) FROM "badges" WHERE "name" = 'Student'	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( `date` AS DATE ) ) = 2010 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( `id` ) - CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( `date` AS DATE ) ) = 2011 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( `id` ) FROM `badges` WHERE `name` = 'Student';	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "date" AS DATE ) ) = 2010 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) - CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "date" AS DATE )) = 2011 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) FROM "badges" WHERE "name" = 'Student'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( "date" AS TIM... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	syntax error at or near "AS" LINE 1: ...ST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( `date` AS DATE ) ... ^	√
SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( `creationdate` AS DATETIME ) , '%Y' ) = '2010' THEN 1 ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN DATE_FORMAT( CAST( `creationdate` AS DATETIME ) , '%Y' ) = '2011' THEN 1 ELSE 0 END ) FROM `votes`	SELECT CAST(SUM(CASE WHEN TO_CHAR(CAST("creationdate" AS TIMESTAMP), 'YYYY') = '2010' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN TO_CHAR(CAST("creationdate" AS TIMESTAMP), 'YYYY') = '2011' THEN 1 ELSE 0 END), 0) FROM "votes"		SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( "creationdate" AS TIMESTAMP ( 0 ) ) , '' ) = '2010' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) / SUM( CASE WHEN DATE_FORMAT( CAST( "creationdate" AS TIMESTAMP ( 0 ) ) , '' ) = '2011' THEN 1 ELSE 0 END ) FROM "votes"	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM `creationdate`) = 2010 THEN 1 ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN EXTRACT(YEAR FROM `creationdate`) = 2011 THEN 1 ELSE 0 END ) FROM `votes`;	SELECT CAST( SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "creationdate" AS TIMESTAMP ) ) = 2010 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) / SUM( CASE WHEN EXTRACT(YEAR FROM CAST("creationdate" AS TIMESTAMP)) = '2011' THEN 1 ELSE 0 END ) FROM "votes"
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( "creationdate... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	syntax error at or near ")" LINE 1: ...T( SUM( CASE WHEN EXTRACT(YEAR FROM `creationdate`) = 2010 T... ^	√
SELECT CAST( SUM( CASE WHEN `t2`.`score` > 50 THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `t1`.`id` ) FROM `users` AS `t1` INNER JOIN `posts` AS `t2` ON `t1`.`id` = `t2`.`owneruserid` INNER JOIN ( SELECT MAX( `reputation` ) AS `max_reputation` FROM `users` ) AS `t3` ON `t1`.`reputation` = `t3`.`max_reputation`	SELECT CAST(CAST(SUM(CASE WHEN "t2"."score" > 50 THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("t1"."id"), 0) FROM "users" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."id" = "t2"."owneruserid" INNER JOIN (SELECT MAX("reputation") AS "max_reputation" FROM "users") AS "t3" ON "t1"."reputation" = "t3"."max_reputation"	select ((cast(sum(case when "t2"."score" > 50 then 1 else 0 end) as double precision) * 100) / count("t1"."id")) from "users" as "t1" join "posts" as "t2" on "t1"."id" = "t2"."owneruserid" join ( select max("reputation") as "max_reputation" from "users" ) as "t3" on "t1"."reputation" = "t3"."max_reputation"	SELECT CAST( SUM( CASE WHEN "t2"."score" > 50 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."id" ) FROM "users" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."id" = "t2"."owneruserid" INNER JOIN ( SELECT MAX( "reputation" ) AS "max_reputation" FROM "users" ) AS "t3" ON "t1"."reputation" = "t3"."max_reputation" ;	SELECT CAST( SUM( CASE WHEN t2.score > 50 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( t1.id ) FROM users AS t1 INNER JOIN posts AS t2 ON t1.id = t2.owneruserid INNER JOIN ( SELECT MAX( reputation ) AS max_reputation FROM users ) AS t3 ON t1.reputation = t3.max_reputation	SELECT CAST( SUM( CASE WHEN "t2"."score" > 50 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."id" ) FROM "users" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."id" = "t2"."owneruserid" INNER JOIN ( SELECT MAX( "reputation" ) AS "max_reputation" FROM "users" ) AS "t3" ON "t1"."reputation" = "t3"."max_reputation"
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( CASE WHEN `t2`.`language` = 'Chinese Simplified' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `t1`.`id` ) FROM `cards` AS `t1` INNER JOIN `foreign_data` AS `t2` ON `t1`.`uuid` = `t2`.`uuid`	SELECT CAST(CAST(SUM(CASE WHEN "t2"."language" = 'Chinese Simplified' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("t1"."id"), 0) FROM "cards" AS "t1" INNER JOIN "foreign_data" AS "t2" ON "t1"."uuid" = "t2"."uuid"	select ((cast(sum(case when "t2"."language" = 'Chinese Simplified' then 1 else 0 end) as double precision) * 100) / count("t1"."id")) from "cards" as "t1" join "foreign_data" as "t2" on "t1"."uuid" = "t2"."uuid"	SELECT CAST( SUM( CASE WHEN "t2"."language" = 'Chinese Simplified' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."id" ) FROM "cards" AS "t1" INNER JOIN "foreign_data" AS "t2" ON "t1"."uuid" = "t2"."uuid" ;	SELECT CAST( SUM( CASE WHEN `t2`.`language` = 'Chinese Simplified' THEN 1 ELSE 0 END ) AS DECIMAL ) * 100 / COUNT( `t1`.`id` ) FROM `cards` AS `t1` INNER JOIN `foreign_data` AS `t2` ON `t1`.`uuid` = `t2`.`uuid`	SELECT CAST( SUM( CASE WHEN "t2"."language" = 'Chinese Simplified' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100.0 / COUNT( "t1"."id" ) FROM "cards" AS "t1" INNER JOIN "foreign_data" AS "t2" ON "t1"."uuid" = "t2"."uuid"
Source Dialect	√	√	√	syntax error at or near "." LINE 1: SELECT CAST( SUM( CASE WHEN `t2`.`language` = 'Chinese Simpl... ^	√
SELECT CAST( SUM( CASE WHEN `istextless` = 0 AND `isstoryspotlight` = 1 THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `id` ) FROM `cards`	SELECT CAST(CAST(SUM(CASE WHEN "istextless" = 0 AND "isstoryspotlight" = 1 THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("id"), 0) FROM "cards"	select ((cast(sum(case when ( "istextless" = 0 and "isstoryspotlight" = 1 ) then 1 else 0 end) as double precision) * 100) / count("id")) from "cards"	SELECT CAST( SUM( CASE WHEN "istextless" = 0 AND "isstoryspotlight" = 1 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) FROM "cards" ;	SELECT CAST( SUM( CASE WHEN `istextless` = 0 AND `isstoryspotlight` = 1 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100.0 / COUNT( `id` ) FROM `cards`	SELECT CAST( SUM( CASE WHEN "istextless" = 0 AND "isstoryspotlight" = 1 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "id" ) FROM "cards"
Source Dialect	√	√	√	syntax error at or near "=" LINE 1: SELECT CAST( SUM( CASE WHEN `istextless` = 0 AND `isstoryspo... ^	√
SELECT CAST( SUM( CASE WHEN NOT `t1`.`cardkingdomfoilid` IS NULL AND NOT `t1`.`cardkingdomid` IS NULL THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `t1`.`id` ) FROM `cards` AS `t1` INNER JOIN `sets` AS `t2` ON `t2`.`code` = `t1`.`setcode` WHERE `t2`.`name` = 'Coldsnap'	SELECT CAST(CAST(SUM(CASE WHEN NOT "t1"."cardkingdomfoilid" IS NULL AND NOT "t1"."cardkingdomid" IS NULL THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("t1"."id"), 0) FROM "cards" AS "t1" INNER JOIN "sets" AS "t2" ON "t2"."code" = "t1"."setcode" WHERE "t2"."name" = 'Coldsnap'	select ((cast(sum(case when ( not ("t1"."cardkingdomfoilid" is null) and not ("t1"."cardkingdomid" is null) ) then 1 else 0 end) as double precision) * 100) / count("t1"."id")) from "cards" as "t1" join "sets" as "t2" on "t2"."code" = "t1"."setcode" where "t2"."name" = 'Coldsnap'	SELECT CAST( SUM( CASE WHEN NOT "t1"."cardkingdomfoilid" IS NULL AND NOT "t1"."cardkingdomid" IS NULL THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."id" ) FROM "cards" AS "t1" INNER JOIN "sets" AS "t2" ON "t2"."code" = "t1"."setcode" WHERE "t2"."name" = 'Coldsnap' ;	SELECT CAST( SUM( CASE WHEN NOT `t1`.`cardkingdomfoilid` IS NULL AND NOT `t1`.`cardkingdomid` IS NULL THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100.0 / COUNT( `t1`.`id` ) FROM `cards` AS `t1` INNER JOIN `sets` AS `t2` ON `t2`.`code` = `t1`.`setcode` WHERE `t2`.`name` = 'Coldsnap'	SELECT CAST( SUM( CASE WHEN NOT "t1"."cardkingdomfoilid" IS NULL AND NOT "t1"."cardkingdomid" IS NULL THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."id" ) FROM "cards" AS "t1" INNER JOIN "sets" AS "t2" ON "t2"."code" = "t1"."setcode" WHERE "t2"."name" = 'Coldsnap'
Source Dialect	√	√	√	syntax error at or near "." LINE 1: SELECT CAST( SUM( CASE WHEN NOT `t1`.`cardkingdomfoilid` IS ... ^	√
SELECT CAST( COUNT( DISTINCT CASE WHEN `t1`.`element` <> 'f' THEN `t2`.`molecule_id` ELSE NULL END ) AS DOUBLE ) * 100 / COUNT( DISTINCT `t2`.`molecule_id` ) FROM `atom` AS `t1` INNER JOIN `molecule` AS `t2` ON `t1`.`molecule_id` = `t2`.`molecule_id` WHERE `t2`.`label` = '+'	SELECT CAST(CAST(COUNT(DISTINCT CASE WHEN "t1"."element" <> 'f' THEN "t2"."molecule_id" ELSE NULL END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT(DISTINCT "t2"."molecule_id"), 0) FROM "atom" AS "t1" INNER JOIN "molecule" AS "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '+'	select ((cast(count(distinct case when "t1"."element" <> 'f' then "t2"."molecule_id" else null end) as double precision) * 100) / count(distinct "t2"."molecule_id")) from "atom" as "t1" join "molecule" as "t2" on "t1"."molecule_id" = "t2"."molecule_id" where "t2"."label" = '+'	SELECT CAST( COUNT( DISTINCT CASE WHEN "t1"."element" <> 'f' THEN "t2"."molecule_id" ELSE NULL END ) AS DOUBLE PRECISION ) * 100 / COUNT( DISTINCT "t2"."molecule_id" ) FROM "atom" AS "t1" INNER JOIN "molecule" AS "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '+' ;	SELECT CAST(COUNT(DISTINCT CASE WHEN t1.element <> 'f' THEN t2.molecule_id ELSE NULL END) AS DOUBLE) * 100.0 / COUNT(DISTINCT t2.molecule_id) FROM atom AS t1 INNER JOIN molecule AS t2 ON t1.molecule_id = t2.molecule_id WHERE t2.label = '+'	SELECT CAST( COUNT( DISTINCT CASE WHEN "t1"."element" <> 'f' THEN "t2"."molecule_id" ELSE NULL END ) AS DOUBLE PRECISION ) * 100 / COUNT( DISTINCT "t2"."molecule_id" ) FROM "atom" AS "t1" INNER JOIN "molecule" AS "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '+'
Source Dialect	√	√	√	type "double" does not exist LINE 1: ...ment <> 'f' THEN t2.molecule_id ELSE NULL END) AS DOUBLE) * ... ^	√
SELECT CAST( COUNT( `t2`.`bond_id` ) AS DOUBLE ) / COUNT( `t1`.`atom_id` ) FROM `atom` AS `t1` INNER JOIN `connected` AS `t2` ON `t1`.`atom_id` = `t2`.`atom_id` WHERE `t1`.`element` = 'i'	SELECT CAST(COUNT("t2"."bond_id") AS DOUBLE PRECISION) / NULLIF(COUNT("t1"."atom_id"), 0) FROM "atom" AS "t1" INNER JOIN "connected" AS "t2" ON "t1"."atom_id" = "t2"."atom_id" WHERE "t1"."element" = 'i'	select (cast(count("t2"."bond_id") as double precision) / count("t1"."atom_id")) from "atom" as "t1" join "connected" as "t2" on "t1"."atom_id" = "t2"."atom_id" where "t1"."element" = 'i'	SELECT CAST( COUNT( "t2"."bond_id" ) AS DOUBLE PRECISION ) / COUNT( "t1"."atom_id" ) FROM "atom" AS "t1" INNER JOIN "connected" AS "t2" ON "t1"."atom_id" = "t2"."atom_id" WHERE "t1"."element" = 'i' ;	SELECT CAST(COUNT(t2."bond_id") AS DOUBLE PRECISION) / COUNT(t1."atom_id") FROM "atom" AS t1 INNER JOIN "connected" AS t2 ON t1."atom_id" = t2."atom_id" WHERE t1."element" = 'i';	SELECT CAST( COUNT( "t2"."bond_id" ) AS DOUBLE PRECISION ) / COUNT( "t1"."atom_id" ) FROM "atom" AS "t1" INNER JOIN "connected" AS "t2" ON "t1"."atom_id" = "t2"."atom_id" WHERE "t1"."element" = 'i'
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( `status` = 'C' ) AS DOUBLE ) * 100 / COUNT( `account_id` ) FROM `loan` WHERE `amount` < 100000	SELECT CAST(CAST(SUM("status" = 'C') AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("account_id"), 0) FROM "loan" WHERE "amount" < 100000	select ((cast(sum(("status" = 'C')) as double precision) * 100) / count("account_id")) from "loan" where "amount" < 100000	SELECT CAST( SUM( "status" = 'C' ) AS DOUBLE ) * 100 / COUNT( "account_id" ) FROM "loan" WHERE "amount" < 100000	SELECT CAST( SUM( `status` = 'C' ) AS DOUBLE PRECISION ) * 100.0 / COUNT( `account_id` ) FROM `loan` WHERE `amount` < 100000;	SELECT CAST( COUNT( CASE WHEN "status" = 'C' THEN 1 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "account_id" ) FROM "loan" WHERE "amount" < 100000
Source Dialect	function sum(boolean) does not exist LINE 1: SELECT CAST(CAST(SUM("status" = 'C') AS DOUBLE PRECISION) * ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	function sum(boolean) does not exist LINE 1: select ((cast(sum(("status" = 'C')) as double precision) * 1... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	type "double" does not exist LINE 1: SELECT CAST( SUM( "status" = 'C' ) AS DOUBLE ) * 100 / COUNT... ^	syntax error at or near "=" LINE 1: SELECT CAST( SUM( `status` = 'C' ) AS DOUBLE PRECISION ) * 1... ^	√
SELECT CAST( SUM( `t2`.`gender` = 'F' ) AS DOUBLE ) * 100 / COUNT( `t2`.`client_id` ) FROM `district` AS `t1` INNER JOIN `client` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` WHERE `t1`.`a11` > 10000	SELECT CAST(CAST(SUM("t2"."gender" = 'F') AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("t2"."client_id"), 0) FROM "district" AS "t1" INNER JOIN "client" AS "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t1"."a11" > 10000	select ((cast(sum(("t2"."gender" = 'F')) as double precision) * 100) / count("t2"."client_id")) from "district" as "t1" join "client" as "t2" on "t1"."district_id" = "t2"."district_id" where "t1"."a11" > 10000	SELECT CAST( SUM( "t2"."gender" = 'F' ) AS DOUBLE ) * 100 / COUNT( "t2"."client_id" ) FROM "district" AS "t1" INNER JOIN "client" AS "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t1"."a11" > 10000	SELECT CAST( SUM( `t2`.`gender` = 'F' ) AS DOUBLE PRECISION ) * 100.0 / COUNT( `t2`.`client_id` ) FROM `district` AS `t1` INNER JOIN `client` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` WHERE `t1`.`a11` > 10000;	SELECT CAST(COUNT(CASE WHEN "t2"."gender" = 'F' THEN 1 END) AS DOUBLE PRECISION) * 100 / COUNT( t2.client_id ) FROM "district" AS "t1" INNER JOIN "client" AS "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t1"."a11" > 10000
Source Dialect	function sum(boolean) does not exist LINE 1: SELECT CAST(CAST(SUM("t2"."gender" = 'F') AS DOUBLE PRECISIO... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	function sum(boolean) does not exist LINE 1: select ((cast(sum(("t2"."gender" = 'F')) as double precision... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	type "double" does not exist LINE 1: SELECT CAST( SUM( "t2"."gender" = 'F' ) AS DOUBLE ) * 100 / ... ^	syntax error at or near "." LINE 1: SELECT CAST( SUM( `t2`.`gender` = 'F' ) AS DOUBLE PRECISION ... ^	√
SELECT CAST( ( SUM( CASE WHEN DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) = '1997' THEN `t1`.`amount` ELSE 0 END ) - SUM( CASE WHEN DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) = '1996' THEN `t1`.`amount` ELSE 0 END ) ) AS DOUBLE ) * 100 / SUM( CASE WHEN DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) = '1996' THEN `t1`.`amount` ELSE 0 END ) FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` INNER JOIN `disp` AS `t3` ON `t3`.`account_id` = `t2`.`account_id` INNER JOIN `client` AS `t4` ON `t4`.`client_id` = `t3`.`client_id` WHERE `t4`.`gender` = 'M' AND `t3`.`type` = 'OWNER'	SELECT CAST(CAST((SUM(CASE WHEN TO_CHAR(CAST("t1"."date" AS TIMESTAMP), 'YYYY') = '1997' THEN "t1"."amount" ELSE 0 END) - SUM(CASE WHEN TO_CHAR(CAST("t1"."date" AS TIMESTAMP), 'YYYY') = '1996' THEN "t1"."amount" ELSE 0 END)) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN TO_CHAR(CAST("t1"."date" AS TIMESTAMP), 'YYYY') = '1996' THEN "t1"."amount" ELSE 0 END), 0) FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "disp" AS "t3" ON "t3"."account_id" = "t2"."account_id" INNER JOIN "client" AS "t4" ON "t4"."client_id" = "t3"."client_id" WHERE "t4"."gender" = 'M' AND "t3"."type" = 'OWNER'		SELECT CAST( ( SUM( CASE WHEN DATE_FORMAT( CAST( "t1"."date" AS TIMESTAMP ( 0 ) ) , '' ) = '1997' THEN "t1"."amount" ELSE 0 END ) - SUM( CASE WHEN DATE_FORMAT( CAST( "t1"."date" AS TIMESTAMP ( 0 ) ) , '' ) = '1996' THEN "t1"."amount" ELSE 0 END ) ) AS DOUBLE PRECISION ) * 100 / SUM( CASE WHEN DATE_FORMAT( CAST( "t1"."date" AS TIMESTAMP ( 0 ) ) , '' ) = '1996' THEN "t1"."amount" ELSE 0 END ) FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "disp" AS "t3" ON "t3"."account_id" = "t2"."account_id" INNER JOIN "client" AS "t4" ON "t4"."client_id" = "t3"."client_id" WHERE "t4"."gender" = 'M' AND "t3"."type" = 'OWNER'	SELECT CAST( ( SUM( CASE WHEN EXTRACT(YEAR FROM `t1`.`date`) = 1997 THEN `t1`.`amount` ELSE 0 END ) - SUM( CASE WHEN EXTRACT(YEAR FROM `t1`.`date`) = 1996 THEN `t1`.`amount` ELSE 0 END ) ) AS DOUBLE ) * 100 / SUM( CASE WHEN EXTRACT(YEAR FROM `t1`.`date`) = 1996 THEN `t1`.`amount` ELSE 0 END ) FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` INNER JOIN `disp` AS `t3` ON `t3`.`account_id` = `t2`.`account_id` INNER JOIN `client` AS `t4` ON `t4`.`client_id` = `t3`.`client_id` WHERE `t4`.`gender` = 'M' AND `t3`.`type` = 'OWNER'	SELECT CAST( ( SUM( CASE WHEN EXTRACT(YEAR FROM "t1"."date") = 1997 THEN "t1"."amount" ELSE 0 END ) - SUM( CASE WHEN EXTRACT(YEAR FROM "t1"."date") = 1996 THEN "t1"."amount" ELSE 0 END ) ) AS DOUBLE PRECISION) * 100 / SUM( CASE WHEN EXTRACT(YEAR FROM CAST( "t1"."date" AS TIMESTAMP )) = '1996' THEN "t1"."amount" ELSE 0 END ) FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "disp" AS "t3" ON "t3"."account_id" = "t2"."account_id" INNER JOIN "client" AS "t4" ON "t4"."client_id" = "t3"."client_id" WHERE "t4"."gender" = 'M' AND "t3"."type" = 'OWNER'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: SELECT CAST( ( SUM( CASE WHEN DATE_FORMAT( CAST( "t1"."date"... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	syntax error at or near "." LINE 1: ...LECT CAST( ( SUM( CASE WHEN EXTRACT(YEAR FROM `t1`.`date`) =... ^	√
SELECT SUM( `currency` = 'CZK' ) - SUM( `currency` = 'EUR' ) FROM `customers` WHERE `segment` = 'SME'	SELECT SUM("currency" = 'CZK') - SUM("currency" = 'EUR') FROM "customers" WHERE "segment" = 'SME'	select (sum(("currency" = 'CZK')) - sum(("currency" = 'EUR'))) from "customers" where "segment" = 'SME'	SELECT SUM( "currency" = 'CZK' ) - SUM( "currency" = 'EUR' ) FROM "customers" WHERE "segment" = 'SME'	SELECT SUM(`currency` = 'CZK') - SUM(`currency` = 'EUR') FROM "customers" WHERE "segment" = 'SME';	SELECT COUNT(CASE WHEN "currency" = 'CZK' THEN 1 END) - COUNT(CASE WHEN "currency" = 'EUR' THEN 1 END) FROM "customers" WHERE "segment" = 'SME'
Source Dialect	function sum(boolean) does not exist LINE 1: SELECT SUM("currency" = 'CZK') - SUM("currency" = 'EUR') FRO... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	function sum(boolean) does not exist LINE 1: select (sum(("currency" = 'CZK')) - sum(("currency" = 'EUR')... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	function sum(boolean) does not exist LINE 1: SELECT SUM( "currency" = 'CZK' ) - SUM( "currency" = 'EUR' )... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	syntax error at or near "=" LINE 1: SELECT SUM(`currency` = 'CZK') - SUM(`currency` = 'EUR') FRO... ^	√
SELECT CAST( SUM( CASE WHEN `t2`.`consumption` > 46.73 THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `t1`.`customerid` ) FROM `customers` AS `t1` INNER JOIN `yearmonth` AS `t2` ON `t1`.`customerid` = `t2`.`customerid` WHERE `t1`.`segment` = 'LAM'	SELECT CAST(CAST(SUM(CASE WHEN "t2"."consumption" > 46.73 THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(COUNT("t1"."customerid"), 0) FROM "customers" AS "t1" INNER JOIN "yearmonth" AS "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM'	select ((cast(sum(case when "t2"."consumption" > 46.73 then 1 else 0 end) as double precision) * 100) / count("t1"."customerid")) from "customers" as "t1" join "yearmonth" as "t2" on "t1"."customerid" = "t2"."customerid" where "t1"."segment" = 'LAM'	SELECT CAST( SUM( CASE WHEN "t2"."consumption" > 46.73 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / COUNT( "t1"."customerid" ) FROM "customers" AS "t1" INNER JOIN "yearmonth" AS "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM' ;	SELECT CAST( SUM( CASE WHEN t2.consumption > 46.73 THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100.0 / COUNT( t1.customerid ) FROM customers AS t1 INNER JOIN yearmonth AS t2 ON t1.customerid = t2.customerid WHERE t1.segment = 'LAM'	SELECT CAST( SUM( CASE WHEN "t2"."consumption" > 46.73 THEN 1 ELSE 0 END ) AS REAL ) * 100 / COUNT( "t1"."customerid" ) FROM "customers" AS "t1" INNER JOIN "yearmonth" AS "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM'
Source Dialect	√	√	√	√	√
SELECT COUNT( `t1`.`transactionid` ) FROM `transactions_1k` AS `t1` INNER JOIN `gasstations` AS `t2` ON `t1`.`gasstationid` = `t2`.`gasstationid` WHERE `t2`.`country` = 'CZE' AND DATE_FORMAT( CAST( `t1`.`date` AS DATETIME ) , '%Y' ) >= '2012'	SELECT COUNT("t1"."transactionid") FROM "transactions_1k" AS "t1" INNER JOIN "gasstations" AS "t2" ON "t1"."gasstationid" = "t2"."gasstationid" WHERE "t2"."country" = 'CZE' AND TO_CHAR(CAST("t1"."date" AS TIMESTAMP), 'YYYY') >= '2012'		SELECT COUNT( "t1"."transactionid" ) FROM "transactions_1k" AS "t1" INNER JOIN "gasstations" AS "t2" ON "t1"."gasstationid" = "t2"."gasstationid" WHERE "t2"."country" = 'CZE' AND DATE_FORMAT( CAST( "t1"."date" AS TIMESTAMP ( 0 ) ) , '' ) >= '2012'	SELECT COUNT( t1.transactionid ) FROM transactions_1k AS t1 INNER JOIN gasstations AS t2 ON t1.gasstationid = t2.gasstationid WHERE t2.country = 'CZE' AND EXTRACT(YEAR FROM t1.date) >= 2012;	SELECT COUNT( "t1"."transactionid" ) FROM "transactions_1k" AS "t1" INNER JOIN "gasstations" AS "t2" ON "t1"."gasstationid" = "t2"."gasstationid" WHERE "t2"."country" = 'CZE' AND EXTRACT(YEAR FROM CAST( "t1"."date" AS TIMESTAMP )) >= '2012'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ..."."gasstationid" WHERE "t2"."country" = 'CZE' AND DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT CAST( SUM( CASE WHEN `admission` = '+' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / SUM( CASE WHEN `admission` = '-' THEN 1 ELSE 0 END ) FROM `patient` WHERE `sex` = 'M'	SELECT CAST(CAST(SUM(CASE WHEN "admission" = '+' THEN 1 ELSE 0 END) AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF(SUM(CASE WHEN "admission" = '-' THEN 1 ELSE 0 END), 0) FROM "patient" WHERE "sex" = 'M'	select ((cast(sum(case when "admission" = '+' then 1 else 0 end) as double precision) * 100) / sum(case when "admission" = '-' then 1 else 0 end)) from "patient" where "sex" = 'M'	SELECT CAST( SUM( CASE WHEN "admission" = '+' THEN 1 ELSE 0 END ) AS DOUBLE PRECISION ) * 100 / SUM( CASE WHEN "admission" = '-' THEN 1 ELSE 0 END ) FROM "patient" WHERE "sex" = 'M' ;	SELECT CAST( SUM( CASE WHEN `admission` = '+' THEN 1 ELSE 0 END ) AS FLOAT ) * 100.0 / SUM( CASE WHEN `admission` = '-' THEN 1 ELSE 0 END ) FROM `patient` WHERE `sex` = 'M'	SELECT CAST( SUM( CASE WHEN "admission" = '+' THEN 1 ELSE 0 END ) AS REAL ) * 100 / SUM( CASE WHEN "admission" = '-' THEN 1 ELSE 0 END ) FROM "patient" WHERE "sex" = 'M'
Source Dialect	√	√	√	syntax error at or near "=" LINE 1: SELECT CAST( SUM( CASE WHEN `admission` = '+' THEN 1 ELSE 0 ... ^	√
SELECT COUNT( * ) FROM `patient` WHERE DATE_FORMAT( CAST( `description` AS DATETIME ) , '%Y' ) = '1997' AND `sex` = 'F' AND `admission` = '-'	SELECT COUNT(*) FROM "patient" WHERE TO_CHAR(CAST("description" AS TIMESTAMP), 'YYYY') = '1997' AND "sex" = 'F' AND "admission" = '-'		SELECT COUNT( * ) FROM "patient" WHERE DATE_FORMAT( CAST( "description" AS TIMESTAMP ( 0 ) ) , '' ) = '1997' AND "sex" = 'F' AND "admission" = '-'	SELECT COUNT(*) FROM "patient" WHERE EXTRACT(YEAR FROM CAST("description" AS TIMESTAMP)) = 1997 AND "sex" = 'F' AND "admission" = '-';	SELECT COUNT( * ) FROM "patient" WHERE TO_CHAR(EXTRACT(YEAR FROM CAST( "description" AS TIMESTAMP )), 'FM99999') = '1997' AND "sex" = 'F' AND "admission" = '-'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: SELECT COUNT( * ) FROM "patient" WHERE DATE_FORMAT( CAST( "d... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT COUNT( * ) FROM `patient` AS `t1` INNER JOIN `examination` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t1`.`sex` = 'F' AND DATE_FORMAT( CAST( `t2`.`examination date` AS DATETIME ) , '%Y' ) = '1997' AND `t2`.`thrombosis` = 1	SELECT COUNT(*) FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."sex" = 'F' AND TO_CHAR(CAST("t2"."examination date" AS TIMESTAMP), 'YYYY') = '1997' AND "t2"."thrombosis" = 1		SELECT COUNT( * ) FROM patient AS t1 INNER JOIN examination AS t2 ON t1.id = t2.id WHERE t1.sex = 'F' AND DATE_FORMAT( CAST( t2.examination date AS DATETIME ) , '%Y' ) = '1997' AND t2.thrombosis = 1	SELECT COUNT(*) FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."sex" = 'F' AND EXTRACT(YEAR FROM "t2"."examination date") = 1997 AND "t2"."thrombosis" = 1;	SELECT COUNT( * ) FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."sex" = 'F' AND TO_CHAR(CAST("t2"."examination date" AS TIMESTAMP), 'YYYY') = '1997' AND "t2"."thrombosis" = 1
Source Dialect	√	can't execute an empty query	syntax error at or near "date" LINE 1: ...1.sex = 'F' AND DATE_FORMAT( CAST( t2.examination date AS DA... ^	√	√
SELECT `t1`.`date` , DATE_FORMAT( CAST( `t2`.`first date` AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t2`.`birthday` AS DATETIME ) , '%Y' ) , `t2`.`birthday` FROM `laboratory` AS `t1` INNER JOIN `patient` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`diagnosis` = 'SJS' AND NOT `t2`.`birthday` IS NULL ORDER BY `t2`.`birthday` ASC LIMIT 1	SELECT "t1"."date", TO_CHAR(CAST("t2"."first date" AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t2"."birthday" AS TIMESTAMP), 'YYYY'), "t2"."birthday" FROM "laboratory" AS "t1" INNER JOIN "patient" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."diagnosis" = 'SJS' AND NOT "t2"."birthday" IS NULL ORDER BY "t2"."birthday" ASC NULLS FIRST LIMIT 1		SELECT t1.date , DATE_FORMAT( CAST( t2.first date AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( t2.birthday AS TIMESTAMP(0) ) , '%Y' ) , t2.birthday FROM laboratory AS t1 INNER JOIN patient AS t2 ON t1.id = t2.id WHERE t2.diagnosis = 'SJS' AND NOT t2.birthday IS NULL ORDER BY t2.birthday ASC LIMIT 1	SELECT t1.date, EXTRACT(YEAR FROM CAST(t2.first_date AS TIMESTAMP)) - EXTRACT(YEAR FROM CAST(t2.birthday AS TIMESTAMP)) AS age, t2.birthday FROM laboratory AS t1 INNER JOIN patient AS t2 ON t1.id = t2.id WHERE t2.diagnosis = 'SJS' AND t2.birthday IS NOT NULL ORDER BY t2.birthday ASC LIMIT 1	SELECT t1.date, EXTRACT(YEAR FROM CAST(t2."first date" AS TIMESTAMP)) - EXTRACT(YEAR FROM CAST(t2."birthday" AS TIMESTAMP)), t2."birthday" FROM laboratory AS t1 INNER JOIN patient AS t2 ON t1.id = t2.id WHERE t2."diagnosis" = 'SJS' AND t2."birthday" IS NOT NULL ORDER BY t2."birthday" ASC LIMIT 1
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST("t2"."first date" AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near "date" LINE 1: SELECT t1.date , DATE_FORMAT( CAST( t2.first date AS DATETIM... ^	column t2.first_date does not exist LINE 1: SELECT t1.date, EXTRACT(YEAR FROM CAST(t2.first_date AS TIME... ^ HINT: Perhaps you meant to reference the column "t2.first date".	√
SELECT COUNT( `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `examination` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE DATE_FORMAT( CAST( `t2`.`examination date` AS DATETIME ) , '%Y' ) BETWEEN '1990' AND '1993' AND DATE_FORMAT( CAST( `t2`.`examination date` AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) < '18'	SELECT COUNT("t1"."id") FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR(CAST("t2"."examination date" AS TIMESTAMP), 'YYYY') BETWEEN '1990' AND '1993' AND TO_CHAR(CAST("t2"."examination date" AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') < '18'		SELECT COUNT( t1.id ) FROM patient AS t1 INNER JOIN examination AS t2 ON t1.id = t2.id WHERE DATE_FORMAT( CAST( t2.examination date AS DATETIME ) , '%Y' ) BETWEEN '1990' AND '1993' AND DATE_FORMAT( CAST( t2.examination date AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( t1.birthday AS TIMESTAMP(0) ) , '%Y' ) < '18'	SELECT COUNT( t1.id ) FROM patient AS t1 INNER JOIN examination AS t2 ON t1.id = t2.id WHERE EXTRACT(YEAR FROM AGE(CAST(t2.examination_date AS DATE), CAST(t1.birthday AS DATE))) BETWEEN 18 AND 21	SELECT COUNT( "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR(CAST("t2"."examination date" AS TIMESTAMP), 'YYYY') BETWEEN '1990' AND '1993' AND EXTRACT(YEAR FROM CAST("t2"."examination date" AS TIMESTAMP)) - EXTRACT(YEAR FROM CAST("t1"."birthday" AS TIMESTAMP)) < '18'
Source Dialect	operator does not exist: text - text LINE 1: ...ST("t2"."examination date" AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near "date" LINE 1: ...d = t2.id WHERE DATE_FORMAT( CAST( t2.examination date AS DA... ^	column t2.examination_date does not exist LINE 1: ...ON t1.id = t2.id WHERE EXTRACT(YEAR FROM AGE(CAST(t2.examina... ^ HINT: Perhaps you meant to reference the column "t2.examination date".	√
SELECT DISTINCT `t1`.`id` FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t1`.`admission` = '-' AND `t2`.`t-bil` < 2.0 AND `t2`.`date` LIKE '1991-10-%'	SELECT DISTINCT "t1"."id" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."admission" = '-' AND "t2"."t-bil" < 2.0 AND "t2"."date" LIKE '1991-10-%'	select distinct "t1"."id" from "patient" as "t1" join "laboratory" as "t2" on "t1"."id" = "t2"."id" where ( "t1"."admission" = '-' and "t2"."t-bil" < 2.0 and cast("t2"."date" as varchar) like '1991-10-%' )	SELECT DISTINCT "t1"."id" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."admission" = '-' AND "t2"."t" - "bil" < 2.0 AND "t2"."date" LIKE '1991-10-%'	SELECT DISTINCT t1.id FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t1.admission = '-' AND t2."t-bil" < 2.0 AND t2.date LIKE '1991-10-%'	SELECT DISTINCT "t1"."id" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."admission" = '-' AND "t2"."t-bil" < 2.0 AND "t2"."date"::date >= '1991-10-01' AND "t2"."date"::date < '1991-11-01'
Source Dialect	operator does not exist: date ~~ unknown LINE 1: ...ion" = '-' AND "t2"."t-bil" < 2.0 AND "t2"."date" LIKE '1991... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	√	column t2.t does not exist LINE 1: ..."id" = "t2"."id" WHERE "t1"."admission" = '-' AND "t2"."t" -... ^	operator does not exist: date ~~ unknown LINE 1: ....admission = '-' AND t2."t-bil" < 2.0 AND t2.date LIKE '1991... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	√
SELECT COUNT( DISTINCT `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`tg` >= 200 AND DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) > 50	SELECT COUNT(DISTINCT "t1"."id") FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."tg" >= 200 AND TO_CHAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') > 50		SELECT COUNT( DISTINCT t1.id ) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.tg >= 200 AND CAST(DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(0) ) , '' ) - DATE_FORMAT( CAST( t1.birthday AS TIMESTAMP(0) ) , '' ) AS INT) > 50	SELECT COUNT(DISTINCT t1.id) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.tg >= 200 AND EXTRACT(YEAR FROM AGE(CURRENT_DATE, t1.birthday)) > 50	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."tg" >= 200 AND EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM CAST("t1"."birthday" AS TIMESTAMP)) > 50
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near ")" LINE 1: ...00 AND CAST(DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMES... ^	√	√
SELECT COUNT( DISTINCT `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) BETWEEN '1936' AND '1956' AND `t1`.`sex` = 'M' AND `t2`.`cpk` >= 250	SELECT COUNT(DISTINCT "t1"."id") FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') BETWEEN '1936' AND '1956' AND "t1"."sex" = 'M' AND "t2"."cpk" >= 250		SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE DATE_FORMAT( CAST( "t1"."birthday" AS TIMESTAMP ( 0 ) ) , '' ) BETWEEN '1936' AND '1956' AND "t1"."sex" = 'M' AND "t2"."cpk" >= 250	SELECT COUNT(DISTINCT t1.id) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE EXTRACT(YEAR FROM t1.birthday) BETWEEN 1936 AND 1956 AND t1.sex = 'M' AND t2.cpk >= 250;	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE EXTRACT(YEAR FROM CAST( "t1"."birthday" AS TIMESTAMP )) BETWEEN '1936' AND '1956' AND "t1"."sex" = 'M' AND "t2"."cpk" >= 250
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ...aboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT DISTINCT `t1`.`id` , `t1`.`sex` , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`glu` >= 180 AND `t2`.`t-cho` < 250	SELECT DISTINCT "t1"."id", "t1"."sex", TO_CHAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."glu" >= 180 AND "t2"."t-cho" < 250		SELECT DISTINCT t1.id , t1.sex , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(0) ) , '' ) - DATE_FORMAT( CAST( t1.birthday AS TIMESTAMP(0) ) , '' ) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.glu >= 180 AND t2.t-cho < 250	SELECT DISTINCT t1.id, t1.sex, EXTRACT(YEAR FROM AGE(CURRENT_DATE, t1.birthday)) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.glu >= 180 AND t2."t-cho" < 250;	SELECT DISTINCT "t1"."id" , "t1"."sex" , EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM CAST("t1"."birthday" AS TIMESTAMP)) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."glu" >= 180 AND "t2"."t-cho" < 250
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near ")" LINE 1: ... , t1.sex , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMES... ^	Inconsistent Result	√
SELECT DISTINCT `t1`.`id` , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t1`.`id` IN ( SELECT `id` FROM `laboratory` WHERE `hct` >= 52 GROUP BY `id` HAVING COUNT( `id` ) >= 2 )	SELECT DISTINCT "t1"."id", TO_CHAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" IN (SELECT "id" FROM "laboratory" WHERE "hct" >= 52 GROUP BY "id" HAVING COUNT("id") >= 2)		SELECT DISTINCT t1.id , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(0) ) , '' ) - DATE_FORMAT( CAST( t1.birthday AS TIMESTAMP(0) ) , '' ) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t1.id IN ( SELECT id FROM laboratory WHERE hct >= 52 GROUP BY id HAVING COUNT( id ) >= 2 )	SELECT DISTINCT t1.id, EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM t1.birthday) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t1.id IN ( SELECT id FROM laboratory WHERE hct >= 52 GROUP BY id HAVING COUNT(id) >= 2 )	SELECT DISTINCT "t1"."id" , EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM CAST("t1"."birthday" AS TIMESTAMP)) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" IN ( SELECT "id" FROM "laboratory" WHERE "hct" >= 52 GROUP BY "id" HAVING COUNT( "id" ) >= 2 )
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near ")" LINE 1: ...NCT t1.id , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMES... ^	√	√
SELECT DISTINCT `t1`.`id` FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`plt` BETWEEN 100 AND 400 AND DATE_FORMAT( CAST( `t2`.`date` AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) < 50 AND DATE_FORMAT( CAST( `t2`.`date` AS DATETIME ) , '%Y' ) = '1984'	SELECT DISTINCT "t1"."id" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND TO_CHAR(CAST("t2"."date" AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') < 50 AND TO_CHAR(CAST("t2"."date" AS TIMESTAMP), 'YYYY') = '1984'		SELECT DISTINCT "t1"."id" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND CAST( DATE_FORMAT( CAST( "t2"."date" AS TIMESTAMP ( 0 ) ) , '' ) - DATE_FORMAT( CAST( "t1"."birthday" AS TIMESTAMP ( 0 ) ) , '' ) AS INT ) < 50 AND DATE_FORMAT( CAST( "t2"."date" AS TIMESTAMP ( 0 ) ) , '' ) = '1984'	SELECT DISTINCT t1.id FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.plt BETWEEN 100 AND 400 AND EXTRACT(YEAR FROM t2.date) - EXTRACT(YEAR FROM t1.birthday) < 50 AND EXTRACT(YEAR FROM t2.date) = 1984;	SELECT DISTINCT "t1"."id" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND EXTRACT(YEAR FROM CAST("t2"."date" AS TIMESTAMP)) - EXTRACT(YEAR FROM CAST("t1"."birthday" AS TIMESTAMP)) < 50 AND EXTRACT(YEAR FROM CAST("t2"."date" AS TIMESTAMP)) = 1984
Source Dialect	operator does not exist: text - text LINE 1: ...D TO_CHAR(CAST("t2"."date" AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ...d" WHERE "t2"."plt" BETWEEN 100 AND 400 AND CAST( DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT COUNT( `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`iga` BETWEEN 80 AND 500 AND DATE_FORMAT( CAST( `t1`.`first date` AS DATETIME ) , '%Y' ) > '1990'	SELECT COUNT("t1"."id") FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."iga" BETWEEN 80 AND 500 AND TO_CHAR(CAST("t1"."first date" AS TIMESTAMP), 'YYYY') > '1990'		SELECT COUNT( t1.id ) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.iga BETWEEN 80 AND 500 AND DATE_FORMAT( CAST( t1.first date AS DATETIME ) , '%Y' ) > '1990'	SELECT COUNT( t1.id ) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.iga BETWEEN 80 AND 500 AND EXTRACT(YEAR FROM t1.first_date) > 1990;	SELECT COUNT( "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."iga" BETWEEN 80 AND 500 AND EXTRACT(YEAR FROM CAST( "t1"."first date" AS TIMESTAMP )) > '1990'
Source Dialect	√	can't execute an empty query	syntax error at or near "date" LINE 1: ...ETWEEN 80 AND 500 AND DATE_FORMAT( CAST( t1.first date AS DA... ^	column t1.first_date does not exist LINE 1: ...E t2.iga BETWEEN 80 AND 500 AND EXTRACT(YEAR FROM t1.first_d... ^ HINT: Perhaps you meant to reference the column "t1.first date".	√
SELECT COUNT( DISTINCT `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`cre` >= 1.5 AND YEAR( CURDATE( ) ) - YEAR( `t1`.`birthday` ) < 70	SELECT COUNT(DISTINCT "t1"."id") FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."cre" >= 1.5 AND YEAR(CAST(CURDATE() AS DATE)) - YEAR(CAST("t1"."birthday" AS DATE)) < 70	select count(distinct "t1"."id") from "patient" as "t1" join "laboratory" as "t2" on "t1"."id" = "t2"."id" where ( "t2"."cre" >= 1.5 and (extract(year from current_date) - extract(year from "t1"."birthday")) < 70 )	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."cre" >= 1.5 AND EXTRACT( YEAR FROM CURDATE( ) ) - EXTRACT( YEAR FROM "t1"."birthday" ) < 70	SELECT COUNT(DISTINCT t1.id) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.cre >= 1.5 AND EXTRACT(YEAR FROM AGE(CURRENT_DATE, t1.birthday)) < 70;	SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."cre" >= 1.5 AND EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM "t1"."birthday") < 70
Source Dialect	function curdate() does not exist LINE 1: ...= "t2"."id" WHERE "t2"."cre" >= 1.5 AND YEAR(CAST(CURDATE() ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	function curdate() does not exist LINE 1: ...d" WHERE "t2"."cre" >= 1.5 AND EXTRACT( YEAR FROM CURDATE( )... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT `t1`.`name` FROM `league` AS `t1` INNER JOIN `match` AS `t2` ON `t1`.`id` = `t2`.`league_id` WHERE `t2`.`season` = '2009/2010' GROUP BY `t1`.`name` HAVING ( CAST( SUM( `t2`.`home_team_goal` ) AS DOUBLE ) / COUNT( DISTINCT `t2`.`id` ) ) - ( CAST( SUM( `t2`.`away_team_goal` ) AS DOUBLE ) / COUNT( DISTINCT `t2`.`id` ) ) > 0	SELECT "t1"."name" FROM "league" AS "t1" INNER JOIN "match" AS "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING (CAST(SUM("t2"."home_team_goal") AS DOUBLE PRECISION) / NULLIF(COUNT(DISTINCT "t2"."id"), 0)) - (CAST(SUM("t2"."away_team_goal") AS DOUBLE PRECISION) / NULLIF(COUNT(DISTINCT "t2"."id"), 0)) > 0	select "t1"."name" from "league" as "t1" join "match" as "t2" on "t1"."id" = "t2"."league_id" where "t2"."season" = '2009/2010' group by "t1"."name" having ((cast(sum("t2"."home_team_goal") as double precision) / count(distinct "t2"."id")) - (cast(sum("t2"."away_team_goal") as double precision) / count(distinct "t2"."id"))) > 0	SELECT "t1"."name" FROM "league" AS "t1" INNER JOIN "match" AS "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING ( CAST( SUM( "t2"."home_team_goal" ) AS DOUBLE PRECISION ) / COUNT( DISTINCT "t2"."id" ) ) - ( CAST( SUM( "t2"."away_team_goal" ) AS DOUBLE PRECISION ) / COUNT( DISTINCT "t2"."id" ) ) > 0 ;	SELECT t1.name FROM league AS t1 INNER JOIN match AS t2 ON t1.id = t2.league_id WHERE t2.season = '2009/2010' GROUP BY t1.name HAVING ( CAST(SUM(t2.home_team_goal) AS DOUBLE PRECISION) / COUNT(DISTINCT t2.id) ) - ( CAST(SUM(t2.away_team_goal) AS DOUBLE PRECISION) / COUNT(DISTINCT t2.id) ) > 0	SELECT "t1"."name" FROM "league" AS "t1" INNER JOIN "match" AS "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING ( CAST( SUM( "t2"."home_team_goal" ) AS FLOAT8 ) / COUNT( DISTINCT "t2"."id" ) ) - ( CAST( SUM( "t2"."away_team_goal" ) AS FLOAT8 ) / COUNT( DISTINCT "t2"."id" ) ) > 0
Source Dialect	√	√	√	√	√
SELECT `t2`.`overall_rating` FROM `player` AS `t1` INNER JOIN `player_attributes` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE `t1`.`player_name` = 'Gabriel Tamas' AND DATE_FORMAT( CAST( `t2`.`date` AS DATETIME ) , '%Y' ) = '2011'	SELECT "t2"."overall_rating" FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Gabriel Tamas' AND TO_CHAR(CAST("t2"."date" AS TIMESTAMP), 'YYYY') = '2011'		SELECT "t2"."overall_rating" FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Gabriel Tamas' AND DATE_FORMAT( CAST( "t2"."date" AS TIMESTAMP ( 0 ) ) , '' ) = '2011'	SELECT t2."overall_rating" FROM player AS t1 INNER JOIN player_attributes AS t2 ON t1."player_api_id" = t2."player_api_id" WHERE t1."player_name" = 'Gabriel Tamas' AND EXTRACT(YEAR FROM t2."date") = 2011;	SELECT "t2"."overall_rating" FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE "t1"."player_name" = 'Gabriel Tamas' AND TO_CHAR(EXTRACT(YEAR FROM CAST( "t2"."date" AS TIMESTAMP )), 'FM9999') = '2011'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ...d" WHERE "t1"."player_name" = 'Gabriel Tamas' AND DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	function pg_catalog.extract(unknown, text) does not exist LINE 1: ..._id" WHERE t1."player_name" = 'Gabriel Tamas' AND EXTRACT(YE... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√
SELECT COUNT( DISTINCT `t1`.`player_name` ) FROM `player` AS `t1` INNER JOIN `player_attributes` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE DATE_FORMAT( CAST( `t1`.`birthday` AS DATETIME ) , '%Y' ) < '1986' AND `t2`.`defensive_work_rate` = 'high'	SELECT COUNT(DISTINCT "t1"."player_name") FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE TO_CHAR(CAST("t1"."birthday" AS TIMESTAMP), 'YYYY') < '1986' AND "t2"."defensive_work_rate" = 'high'		SELECT COUNT( DISTINCT "t1"."player_name" ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE DATE_FORMAT( CAST( "t1"."birthday" AS TIMESTAMP ( 0 ) ) , '' ) < '1986' AND "t2"."defensive_work_rate" = 'high'	SELECT COUNT(DISTINCT t1.player_name) FROM player AS t1 INNER JOIN player_attributes AS t2 ON t1.player_api_id = t2.player_api_id WHERE EXTRACT(YEAR FROM t1.birthday) < 1986 AND t2.defensive_work_rate = 'high'	SELECT COUNT( DISTINCT "t1"."player_name" ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE TO_CHAR(EXTRACT(YEAR FROM CAST( "t1"."birthday" AS TIMESTAMP )), 'FM9999') < '1986' AND "t2"."defensive_work_rate" = 'high'
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ..."t1"."player_api_id" = "t2"."player_api_id" WHERE DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	function pg_catalog.extract(unknown, text) does not exist LINE 1: ...S t2 ON t1.player_api_id = t2.player_api_id WHERE EXTRACT(YE... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√
SELECT `name` FROM `races` WHERE DATE_FORMAT( CAST( `date` AS DATETIME ) , '%Y' ) = ( SELECT DATE_FORMAT( CAST( `date` AS DATETIME ) , '%Y' ) FROM `races` ORDER BY `date` ASC LIMIT 1 ) AND DATE_FORMAT( CAST( `date` AS DATETIME ) , '%m' ) = ( SELECT DATE_FORMAT( CAST( `date` AS DATETIME ) , '%m' ) FROM `races` ORDER BY `date` ASC LIMIT 1 )	SELECT "name" FROM "races" WHERE TO_CHAR(CAST("date" AS TIMESTAMP), 'YYYY') = (SELECT TO_CHAR(CAST("date" AS TIMESTAMP), 'YYYY') FROM "races" ORDER BY "date" ASC NULLS FIRST LIMIT 1) AND TO_CHAR(CAST("date" AS TIMESTAMP), 'MM') = (SELECT TO_CHAR(CAST("date" AS TIMESTAMP), 'MM') FROM "races" ORDER BY "date" ASC NULLS FIRST LIMIT 1)		SELECT "name" FROM "races" WHERE DATE_FORMAT( CAST( "date" AS TIMESTAMP ( 0 ) ) , '' ) = ( SELECT DATE_FORMAT( CAST( "date" AS TIMESTAMP ( 0 ) ) , '' ) FROM "races" ORDER BY "date" ASC LIMIT 1 ) AND DATE_FORMAT( CAST( "date" AS TIMESTAMP ( 0 ) ) , '' ) = ( SELECT DATE_FORMAT( CAST( "date" AS TIMESTAMP ( 0 ) ) , '' ) FROM "races" ORDER BY "date" ASC LIMIT 1 )	SELECT "name" FROM "races" WHERE EXTRACT(YEAR FROM CAST("date" AS TIMESTAMP)) = ( SELECT EXTRACT(YEAR FROM CAST("date" AS TIMESTAMP)) FROM "races" ORDER BY "date" ASC LIMIT 1 ) AND EXTRACT(MONTH FROM CAST("date" AS TIMESTAMP)) = ( SELECT EXTRACT(MONTH FROM CAST("date" AS TIMESTAMP)) FROM "races" ORDER BY "date" ASC LIMIT 1 )	SELECT "name" FROM "races" WHERE EXTRACT(YEAR FROM CAST( "date" AS TIMESTAMP )) = ( SELECT EXTRACT(YEAR FROM CAST("date" AS TIMESTAMP)) FROM "races" ORDER BY "date" ASC LIMIT 1 ) AND EXTRACT(MONTH FROM CAST("date" AS TIMESTAMP)) = ( SELECT EXTRACT(MONTH FROM CAST("date" AS TIMESTAMP)) FROM "races" ORDER BY "date" ASC LIMIT 1 )
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: SELECT "name" FROM "races" WHERE DATE_FORMAT( CAST( "date" A... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT SUM( `t1`.`points` ) , `t2`.`name` , `t2`.`nationality` FROM `constructorresults` AS `t1` INNER JOIN `constructors` AS `t2` ON `t1`.`constructorid` = `t2`.`constructorid` INNER JOIN `races` AS `t3` ON `t3`.`raceid` = `t1`.`raceid` WHERE `t3`.`name` = 'Monaco Grand Prix' AND `t3`.`year` BETWEEN 1980 AND 2010 GROUP BY `t2`.`name` ORDER BY SUM( `t1`.`points` ) DESC LIMIT 1	SELECT SUM("t1"."points"), "t2"."name", "t2"."nationality" FROM "constructorresults" AS "t1" INNER JOIN "constructors" AS "t2" ON "t1"."constructorid" = "t2"."constructorid" INNER JOIN "races" AS "t3" ON "t3"."raceid" = "t1"."raceid" WHERE "t3"."name" = 'Monaco Grand Prix' AND "t3"."year" BETWEEN 1980 AND 2010 GROUP BY "t2"."name" ORDER BY SUM("t1"."points") DESC NULLS LAST LIMIT 1	select sum("t1"."points"), "t2"."name", "t2"."nationality" from "constructorresults" as "t1" join "constructors" as "t2" on "t1"."constructorid" = "t2"."constructorid" join "races" as "t3" on "t3"."raceid" = "t1"."raceid" where ( "t3"."name" = 'Monaco Grand Prix' and "t3"."year" between 1980 and 2010 ) group by "t2"."name" order by sum("t1"."points") desc fetch next 1 rows only	SELECT SUM( "t1"."points" ) , "t2"."name" , "t2"."nationality" FROM "constructorresults" AS "t1" INNER JOIN "constructors" AS "t2" ON "t1"."constructorid" = "t2"."constructorid" INNER JOIN "races" AS "t3" ON "t3"."raceid" = "t1"."raceid" WHERE "t3"."name" = 'Monaco Grand Prix' AND "t3"."year" BETWEEN 1980 AND 2010 GROUP BY "t2"."name" ORDER BY SUM( "t1"."points" ) DESC LIMIT 1	SELECT SUM( t1.points ), t2.name, t2.nationality FROM constructorresults AS t1 INNER JOIN constructors AS t2 ON t1.constructorid = t2.constructorid INNER JOIN races AS t3 ON t3.raceid = t1.raceid WHERE t3.name = 'Monaco Grand Prix' AND t3.year BETWEEN 1980 AND 2010 GROUP BY t2.name ORDER BY SUM( t1.points ) DESC LIMIT 1;	SELECT SUM( "t1"."points" ), "t2"."name", "t2"."nationality" FROM "constructorresults" AS "t1" INNER JOIN "constructors" AS "t2" ON "t1"."constructorid" = "t2"."constructorid" INNER JOIN "races" AS "t3" ON "t3"."raceid" = "t1"."raceid" WHERE "t3"."name" = 'Monaco Grand Prix' AND "t3"."year" BETWEEN 1980 AND 2010 GROUP BY "t2"."name", "t2"."nationality" ORDER BY SUM( "t1"."points" ) DESC LIMIT 1
Source Dialect	column "t2.nationality" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT SUM("t1"."points"), "t2"."name", "t2"."nationality" F... ^	column "t2.nationality" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: select sum("t1"."points"), "t2"."name", "t2"."national... ^	column "t2.nationality" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT SUM( "t1"."points" ) , "t2"."name" , "t2"."nationalit... ^	column "t2.nationality" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT SUM( t1.points ), t2.name, t2.nationality FROM constr... ^	√
SELECT COUNT( `t2`.`school` ) FROM `frpm` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cdscode` = `t2`.`cdscode` WHERE `t2`.`county` = 'Los Angeles' AND `t2`.`charter` = 0 AND CAST( `t1`.`free meal count (k-12)` AS DOUBLE ) * 100 / `t1`.`enrollment (k-12)` < 0.18	SELECT COUNT("t2"."school") FROM "frpm" AS "t1" INNER JOIN "schools" AS "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'Los Angeles' AND "t2"."charter" = 0 AND CAST(CAST("t1"."free meal count (k-12)" AS DOUBLE PRECISION) * 100 AS DOUBLE PRECISION) / NULLIF("t1"."enrollment (k-12)", 0) < 0.18	select count("t2"."school") from "frpm" as "t1" join "schools" as "t2" on "t1"."cdscode" = "t2"."cdscode" where ( "t2"."county" = 'Los Angeles' and "t2"."charter" = 0 and ((cast("t1"."free meal count (k-12)" as double precision) * 100) / "t1"."enrollment (k-12)") < 0.18 )	SELECT COUNT( t2.school ) FROM frpm AS t1 INNER JOIN schools AS t2 ON t1.cdscode = t2.cdscode WHERE t2.county = 'Los Angeles' AND t2.charter = 0 AND CAST( t1.free meal count (k-12) AS DOUBLE ) * 100 / t1.enrollment (k-12) < 0.18	SELECT COUNT( t2."school" ) FROM frpm AS t1 INNER JOIN schools AS t2 ON t1."cdscode" = t2."cdscode" WHERE t2."county" = 'Los Angeles' AND t2."charter" = 0 AND (t1."free meal count (k-12)"::double precision * 100) / t1."enrollment (k-12)" < 0.18;	SELECT COUNT( "t2"."school" ) FROM "frpm" AS "t1" INNER JOIN "schools" AS "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'Los Angeles' AND "t2"."charter" = 0 AND (CAST( "t1"."free meal count (k-12)" AS numeric ) * 100.0) / "t1"."enrollment (k-12)" < 0.18
Source Dialect	√	√	syntax error at or near "meal" LINE 1: ...Los Angeles' AND t2.charter = 0 AND CAST( t1.free meal count... ^	√	√
SELECT `t1`.`account_id` FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` WHERE DATE_FORMAT( CAST( `t2`.`date` AS DATETIME ) , '%Y' ) = '1993' AND `t1`.`duration` > 12 ORDER BY `t1`.`amount` DESC LIMIT 1	SELECT "t1"."account_id" FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" WHERE TO_CHAR(CAST("t2"."date" AS TIMESTAMP), 'YYYY') = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC NULLS LAST LIMIT 1		SELECT "t1"."account_id" FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" WHERE DATE_FORMAT( CAST( "t2"."date" AS TIMESTAMP ( 0 ) ) , '' ) = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC LIMIT 1	SELECT t1.account_id FROM loan AS t1 INNER JOIN account AS t2 ON t1.account_id = t2.account_id WHERE EXTRACT(YEAR FROM t2.date) = 1993 AND t1.duration > 12 ORDER BY t1.amount DESC LIMIT 1	SELECT "t1"."account_id" FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" WHERE EXTRACT(YEAR FROM CAST( "t2"."date" AS TIMESTAMP )) = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC LIMIT 1
Source Dialect	√	can't execute an empty query	function date_format(timestamp without time zone, unknown) does not exist LINE 1: ...2" ON "t1"."account_id" = "t2"."account_id" WHERE DATE_FORMA... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.	√	√
SELECT DISTINCT `t1`.`a2` FROM `district` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` INNER JOIN `trans` AS `t3` ON `t2`.`account_id` = `t3`.`account_id` WHERE `t3`.`type` = 'VYDAJ' AND `t3`.`date` LIKE '1996-01%' ORDER BY `a2` ASC LIMIT 10	SELECT DISTINCT "t1"."a2" FROM "district" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."district_id" = "t2"."district_id" INNER JOIN "trans" AS "t3" ON "t2"."account_id" = "t3"."account_id" WHERE "t3"."type" = 'VYDAJ' AND "t3"."date" LIKE '1996-01%' ORDER BY "a2" ASC NULLS FIRST LIMIT 10	select distinct "t1"."a2" from "district" as "t1" join "account" as "t2" on "t1"."district_id" = "t2"."district_id" join "trans" as "t3" on "t2"."account_id" = "t3"."account_id" where ( "t3"."type" = 'VYDAJ' and cast("t3"."date" as varchar) like '1996-01%' ) order by "a2" asc fetch next 10 rows only	SELECT DISTINCT "t1"."a2" FROM "district" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."district_id" = "t2"."district_id" INNER JOIN "trans" AS "t3" ON "t2"."account_id" = "t3"."account_id" WHERE "t3"."type" = 'VYDAJ' AND "t3"."date" LIKE '1996-01%' ORDER BY "a2" ASC LIMIT 10	SELECT DISTINCT t1.a2 FROM district AS t1 INNER JOIN account AS t2 ON t1.district_id = t2.district_id INNER JOIN trans AS t3 ON t2.account_id = t3.account_id WHERE t3.type = 'VYDAJ' AND t3.date LIKE '1996-01%' ORDER BY t1.a2 ASC LIMIT 10;	SELECT DISTINCT "t1"."a2" FROM "district" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."district_id" = "t2"."district_id" INNER JOIN "trans" AS "t3" ON "t2"."account_id" = "t3"."account_id" WHERE "t3"."type" = 'VYDAJ' AND "t3"."date" >= '1996-01-01' AND "t3"."date" < '1996-02-01' ORDER BY "a2" ASC LIMIT 10
Source Dialect	operator does not exist: date ~~ unknown LINE 1: ...t_id" WHERE "t3"."type" = 'VYDAJ' AND "t3"."date" LIKE '1996... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	√	operator does not exist: date ~~ unknown LINE 1: ...t_id" WHERE "t3"."type" = 'VYDAJ' AND "t3"."date" LIKE '1996... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	operator does not exist: date ~~ unknown LINE 1: ...t3.account_id WHERE t3.type = 'VYDAJ' AND t3.date LIKE '1996... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	√
SELECT `t1`.`client_id` , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS DATETIME ) , '%Y' ) - DATE_FORMAT( CAST( `t3`.`birth_date` AS DATETIME ) , '%Y' ) FROM `disp` AS `t1` INNER JOIN `card` AS `t2` ON `t2`.`disp_id` = `t1`.`disp_id` INNER JOIN `client` AS `t3` ON `t1`.`client_id` = `t3`.`client_id` WHERE `t2`.`type` = 'gold' AND `t1`.`type` = 'OWNER'	SELECT "t1"."client_id", TO_CHAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(CAST("t3"."birth_date" AS TIMESTAMP), 'YYYY') FROM "disp" AS "t1" INNER JOIN "card" AS "t2" ON "t2"."disp_id" = "t1"."disp_id" INNER JOIN "client" AS "t3" ON "t1"."client_id" = "t3"."client_id" WHERE "t2"."type" = 'gold' AND "t1"."type" = 'OWNER'		SELECT t1.client_id , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMESTAMP(0) ) , '' ) - DATE_FORMAT( CAST( t3.birth_date AS TIMESTAMP(0) ) , '' ) FROM disp AS t1 INNER JOIN card AS t2 ON t2.disp_id = t1.disp_id INNER JOIN client AS t3 ON t1.client_id = t3.client_id WHERE t2.type = 'gold' AND t1.type = 'OWNER'	SELECT t1.client_id, EXTRACT(YEAR FROM CURRENT_DATE) - EXTRACT(YEAR FROM t3.birth_date) FROM disp AS t1 INNER JOIN card AS t2 ON t2.disp_id = t1.disp_id INNER JOIN client AS t3 ON t1.client_id = t3.client_id WHERE t2.type = 'gold' AND t1.type = 'OWNER'	SELECT "t1"."client_id" , EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM CAST( "t3"."birth_date" AS TIMESTAMP )) FROM "disp" AS "t1" INNER JOIN "card" AS "t2" ON "t2"."disp_id" = "t1"."disp_id" INNER JOIN "client" AS "t3" ON "t1"."client_id" = "t3"."client_id" WHERE "t2"."type" = 'gold' AND "t1"."type" = 'OWNER'
Source Dialect	operator does not exist: text - text LINE 1: ...HAR(CAST(CURRENT_TIMESTAMP AS TIMESTAMP), 'YYYY') - TO_CHAR(... ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.	can't execute an empty query	syntax error at or near ")" LINE 1: ...client_id , DATE_FORMAT( CAST( CURRENT_TIMESTAMP( ) AS TIMES... ^	√	√

PostgreSQL	SQLGlot	jOOQ	SQLines	GPT-4o	CrackSQL
SELECT CAST( SUM( CASE WHEN TO_CHAR( CAST( "creationdate" AS TIMESTAMP ) , 'YYYY' ) = '2010' THEN 1 ELSE 0 END ) AS REAL ) / NULLIF( SUM( CASE WHEN TO_CHAR( CAST( "creationdate" AS TIMESTAMP ) , 'YYYY' ) = '2011' THEN 1 ELSE 0 END ) , 0 ) FROM "votes"	SELECT CAST(SUM(CASE WHEN DATE_FORMAT(CAST(`creationdate` AS DATETIME), '%Y') = '2010' THEN 1 ELSE 0 END) AS FLOAT) / NULLIF(SUM(CASE WHEN DATE_FORMAT(CAST(`creationdate` AS DATETIME), '%Y') = '2011' THEN 1 ELSE 0 END), 0) FROM `votes`	SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( `creationdate` AS DATETIME ) , '%Y' ) = '2010' THEN 1 ELSE 0 END ) AS DOUBLE ) / SUM( CASE WHEN DATE_FORMAT( CAST( `creationdate` AS DATETIME ) , '%Y' ) = '2011' THEN 1 ELSE 0 END ) FROM `votes`	SELECT CAST( SUM( CASE WHEN DATE_FORMAT( CAST( creationdate AS DATETIME ) , '%Y' ) = '2010' THEN 1 ELSE 0 END ) AS REAL ) / NULLIF( SUM( CASE WHEN DATE_FORMAT( CAST( creationdate AS DATETIME ) , '%Y' ) = '2011' THEN 1 ELSE 0 END ) , 0 ) FROM votes ;	SELECT CAST( SUM( CASE WHEN YEAR( "creationdate" ) = 2010 THEN 1 ELSE 0 END ) AS REAL ) / NULLIF( SUM( CASE WHEN YEAR( "creationdate" ) = 2011 THEN 1 ELSE 0 END ), 0 ) FROM `votes`;	SELECT CAST( SUM( CASE WHEN DATE_FORMAT(`creationdate`, '%Y') = '2010' THEN 1 ELSE 0 END ) AS REAL ) / NULLIF( SUM( CASE WHEN DATE_FORMAT(`creationdate`, '%Y') = '2011' THEN 1 ELSE 0 END ) , 0 ) FROM `votes`
Source Dialect	√	√	√	√	√
SELECT "text" FROM "comments" WHERE "postid" IN ( SELECT "id" FROM "posts" WHERE "viewcount" BETWEEN 100 AND 150 ) ORDER BY "score" DESC NULLS LAST LIMIT 1	SELECT `text` FROM `comments` WHERE `postid` IN (SELECT `id` FROM `posts` WHERE `viewcount` BETWEEN 100 AND 150) ORDER BY `score` DESC LIMIT 1	SELECT `text` FROM `comments` WHERE `postid` IN ( SELECT `id` FROM `posts` WHERE `viewcount` BETWEEN 100 AND 150 ) ORDER BY `score` DESC LIMIT 1	SELECT text FROM comments WHERE postid IN ( SELECT id FROM posts WHERE viewcount BETWEEN 100 AND 150 ) ORDER BY score DESC NULLS LAST LIMIT 1	SELECT `text` FROM `comments` WHERE `postid` IN ( SELECT `id` FROM `posts` WHERE `viewcount` BETWEEN 100 AND 150 ) ORDER BY `score` DESC LIMIT 1	SELECT `text` FROM `comments` WHERE `postid` IN ( SELECT `id` FROM `posts` WHERE `viewcount` BETWEEN 100 AND 150 ) ORDER BY `score` DESC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 1' at line 1")	√	√
SELECT "t2"."street" , "t2"."city" , "t2"."state" , "t2"."zip" FROM "satscores" AS "t1" INNER JOIN "schools" AS "t2" ON "t1"."cds" = "t2"."cdscode" ORDER BY CAST( "t1"."numge1500" AS REAL ) / NULLIF( "t1"."numtsttakr" , 0 ) ASC NULLS FIRST LIMIT 1	SELECT `t2`.`street`, `t2`.`city`, `t2`.`state`, `t2`.`zip` FROM `satscores` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cds` = `t2`.`cdscode` ORDER BY CAST(`t1`.`numge1500` AS FLOAT) / NULLIF(`t1`.`numtsttakr`, 0) ASC LIMIT 1	SELECT `t2`.`street` , `t2`.`city` , `t2`.`state` , `t2`.`zip` FROM `satscores` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cds` = `t2`.`cdscode` ORDER BY CAST( `t1`.`numge1500` AS DOUBLE ) / `t1`.`numtsttakr` ASC LIMIT 1	SELECT t2.street , t2.city , t2.state , t2.zip FROM satscores AS t1 INNER JOIN schools AS t2 ON t1.cds = t2.cdscode ORDER BY CAST( t1.numge1500 AS REAL ) / NULLIF( t1.numtsttakr , 0 ) ASC NULLS FIRST LIMIT 1	SELECT t2.street, t2.city, t2.state, t2.zip FROM satscores AS t1 INNER JOIN schools AS t2 ON t1.cds = t2.cdscode ORDER BY CAST(t1.numge1500 AS REAL) / NULLIF(t1.numtsttakr, 0) ASC NULLS FIRST LIMIT 1	SELECT `t2`.`street`, `t2`.`city`, `t2`.`state`, `t2`.`zip` FROM `satscores` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cds` = `t2`.`cdscode` ORDER BY IFNULL(`t1`.`numge1500` / `t1`.`numtsttakr`, 0) ASC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1' at line 1")	√
SELECT "gsoffered" FROM "schools" ORDER BY ABS( "longitude" ) DESC NULLS LAST LIMIT 1	SELECT `gsoffered` FROM `schools` ORDER BY ABS(`longitude`) DESC LIMIT 1	SELECT `gsoffered` FROM `schools` ORDER BY ABS( `longitude` ) DESC LIMIT 1	SELECT gsoffered FROM schools ORDER BY ABS( longitude ) DESC NULLS LAST LIMIT 1	SELECT `gsoffered` FROM `schools` ORDER BY ABS( `longitude` ) DESC LIMIT 1	SELECT `gsoffered` FROM `schools` ORDER BY ABS(`longitude`) DESC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 1' at line 1")	√	√
SELECT "t2"."admemail1" , "t2"."admemail2" FROM "frpm" AS "t1" INNER JOIN "schools" AS "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."county" = 'San Bernardino' AND "t2"."city" = 'San Bernardino' AND "t2"."doc" :: integer = 54 AND EXTRACT( YEAR FROM "t2"."opendate" ) BETWEEN 2009 AND 2010 AND "t2"."soc" :: integer = 62	SELECT `t2`.`admemail1`, `t2`.`admemail2` FROM `frpm` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cdscode` = `t2`.`cdscode` WHERE `t2`.`county` = 'San Bernardino' AND `t2`.`city` = 'San Bernardino' AND CAST(`t2`.`doc` AS SIGNED) = 54 AND EXTRACT(YEAR FROM `t2`.`opendate`) BETWEEN 2009 AND 2010 AND CAST(`t2`.`soc` AS SIGNED) = 62	SELECT `t2`.`admemail1` , `t2`.`admemail2` FROM `frpm` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cdscode` = `t2`.`cdscode` WHERE `t2`.`county` = 'San Bernardino' AND `t2`.`city` = 'San Bernardino' AND `t2`.`doc` = 54 AND DATE_FORMAT( CAST( `t2`.`opendate` AS DATETIME ) , '%Y' ) BETWEEN '2009' AND '2010' AND `t2`.`soc` = 62	SELECT t2.admemail1 , t2.admemail2 FROM frpm AS t1 INNER JOIN schools AS t2 ON t1.cdscode = t2.cdscode WHERE t2.county = 'San Bernardino' AND t2.city = 'San Bernardino' AND t2.doc :: integer = 54 AND YEAR( t2.opendate ) BETWEEN 2009 AND 2010 AND t2.soc :: integer = 62	SELECT t2.admemail1, t2.admemail2 FROM frpm AS t1 INNER JOIN schools AS t2 ON t1.cdscode = t2.cdscode WHERE t2.county = 'San Bernardino' AND t2.city = 'San Bernardino' AND t2.doc = 54 AND YEAR(t2.opendate) BETWEEN 2009 AND 2010 AND t2.soc = 62;	SELECT `t2`.`admemail1`, `t2`.`admemail2` FROM `frpm` AS `t1` INNER JOIN `schools` AS `t2` ON `t1`.`cdscode` = `t2`.`cdscode` WHERE `t2`.`county` = 'San Bernardino' AND `t2`.`city` = 'San Bernardino' AND `t2`.`doc` = 54 AND YEAR(`t2`.`opendate`) BETWEEN 2009 AND 2010 AND `t2`.`soc` = 62
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':: integer = 54 AND YEAR( t2.opendate ) BETWEEN 2009 AND 2010 AND t2.soc :: inte' at line 1")	√	√
SELECT "t1"."account_id" , ( SELECT MAX( "a11" ) - MIN( "a11" ) FROM "district" ) FROM "account" AS "t1" INNER JOIN "district" AS "t2" ON "t1"."district_id" = "t2"."district_id" INNER JOIN "disp" AS "t3" ON "t1"."account_id" = "t3"."account_id" INNER JOIN "client" AS "t4" ON "t3"."client_id" = "t4"."client_id" WHERE "t2"."district_id" = ( SELECT "district_id" FROM "client" WHERE "gender" = 'F' ORDER BY "birth_date" ASC NULLS FIRST LIMIT 1 ) ORDER BY "t2"."a11" DESC NULLS LAST LIMIT 1	SELECT `t1`.`account_id`, (SELECT MAX(`a11`) - MIN(`a11`) FROM `district`) FROM `account` AS `t1` INNER JOIN `district` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` INNER JOIN `disp` AS `t3` ON `t1`.`account_id` = `t3`.`account_id` INNER JOIN `client` AS `t4` ON `t3`.`client_id` = `t4`.`client_id` WHERE `t2`.`district_id` = (SELECT `district_id` FROM `client` WHERE `gender` = 'F' ORDER BY `birth_date` ASC LIMIT 1) ORDER BY `t2`.`a11` DESC LIMIT 1	SELECT `t1`.`account_id` , ( SELECT MAX( `a11` ) - MIN( `a11` ) FROM `district` ) FROM `account` AS `t1` INNER JOIN `district` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` INNER JOIN `disp` AS `t3` ON `t1`.`account_id` = `t3`.`account_id` INNER JOIN `client` AS `t4` ON `t3`.`client_id` = `t4`.`client_id` WHERE `t2`.`district_id` = ( SELECT `district_id` FROM `client` WHERE `gender` = 'F' ORDER BY `birth_date` ASC LIMIT 1 ) ORDER BY `t2`.`a11` DESC LIMIT 1	SELECT t1.account_id , ( SELECT MAX( a11 ) - MIN( a11 ) FROM district ) FROM account AS t1 INNER JOIN district AS t2 ON t1.district_id = t2.district_id INNER JOIN disp AS t3 ON t1.account_id = t3.account_id INNER JOIN client AS t4 ON t3.client_id = t4.client_id WHERE t2.district_id = ( SELECT district_id FROM client WHERE gender = 'F' ORDER BY birth_date ASC NULLS FIRST LIMIT 1 ) ORDER BY t2.a11 DESC NULLS LAST LIMIT 1	SELECT t1.account_id, ( SELECT MAX( a11 ) - MIN( a11 ) FROM district ) FROM account AS t1 INNER JOIN district AS t2 ON t1.district_id = t2.district_id INNER JOIN disp AS t3 ON t1.account_id = t3.account_id INNER JOIN client AS t4 ON t3.client_id = t4.client_id WHERE t2.district_id = ( SELECT district_id FROM client WHERE gender = 'F' ORDER BY birth_date ASC NULLS FIRST LIMIT 1 ) ORDER BY t2.a11 DESC NULLS LAST LIMIT 1;	SELECT `t1`.`account_id`, ( SELECT MAX( `a11` ) - MIN( `a11` ) FROM `district` ) FROM `account` AS `t1` INNER JOIN `district` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` INNER JOIN `disp` AS `t3` ON `t1`.`account_id` = `t3`.`account_id` INNER JOIN `client` AS `t4` ON `t3`.`client_id` = `t4`.`client_id` WHERE `t2`.`district_id` = ( SELECT `district_id` FROM `client` WHERE `gender` = 'F' ORDER BY `birth_date` ASC LIMIT 1 ) ORDER BY IFNULL(`t2`.`a11`, 0) DESC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1 ) ORDER BY t2.a11 DESC NULLS LAST LIMIT 1' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1 ) ORDER BY t2.a11 DESC NULLS LAST LIMIT 1' at line 1")	√
SELECT "t1"."account_id" FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" WHERE TO_CHAR( CAST( "t2"."date" AS TIMESTAMP ) , 'YYYY' ) = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC NULLS LAST LIMIT 1	SELECT `t1`.`account_id` FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` WHERE DATE_FORMAT(CAST(`t2`.`date` AS DATETIME), '%Y') = '1993' AND `t1`.`duration` > 12 ORDER BY `t1`.`amount` DESC LIMIT 1	SELECT `t1`.`account_id` FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` WHERE DATE_FORMAT( CAST( `t2`.`date` AS DATETIME ) , '%Y' ) = '1993' AND `t1`.`duration` > 12 ORDER BY `t1`.`amount` DESC LIMIT 1	SELECT t1.account_id FROM loan AS t1 INNER JOIN account AS t2 ON t1.account_id = t2.account_id WHERE DATE_FORMAT( CAST( t2.date AS DATETIME ) , '%Y' ) = '1993' AND t1.duration > 12 ORDER BY t1.amount DESC NULLS LAST LIMIT 1	SELECT t1.account_id FROM loan AS t1 INNER JOIN account AS t2 ON t1.account_id = t2.account_id WHERE YEAR(CAST(t2.`date` AS DATETIME)) = 1993 AND t1.`duration` > 12 ORDER BY t1.`amount` DESC LIMIT 1	SELECT `t1`.`account_id` FROM `loan` AS `t1` INNER JOIN `account` AS `t2` ON `t1`.`account_id` = `t2`.`account_id` WHERE YEAR(CAST(`t2`.`date` AS DATE)) = 1993 AND `t1`.`duration` > 12 ORDER BY `t1`.`amount` DESC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 1' at line 1")	√	√
SELECT "t2"."a2" , COUNT( "t1"."client_id" ) FROM "client" AS "t1" INNER JOIN "district" AS "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t1"."gender" = 'F' GROUP BY "t2"."district_id" , "t2"."a2" ORDER BY COUNT( "t1"."client_id" ) DESC NULLS LAST LIMIT 9	SELECT `t2`.`a2`, COUNT(`t1`.`client_id`) FROM `client` AS `t1` INNER JOIN `district` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` WHERE `t1`.`gender` = 'F' GROUP BY `t2`.`district_id`, `t2`.`a2` ORDER BY COUNT(`t1`.`client_id`) DESC LIMIT 9	SELECT `t2`.`a2` , COUNT( `t1`.`client_id` ) FROM `client` AS `t1` INNER JOIN `district` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` WHERE `t1`.`gender` = 'F' GROUP BY `t2`.`district_id` , `t2`.`a2` ORDER BY COUNT( `t1`.`client_id` ) DESC LIMIT 9	SELECT t2.a2 , COUNT( t1.client_id ) FROM client AS t1 INNER JOIN district AS t2 ON t1.district_id = t2.district_id WHERE t1.gender = 'F' GROUP BY t2.district_id , t2.a2 ORDER BY COUNT( t1.client_id ) DESC NULLS LAST LIMIT 9	SELECT t2.a2, COUNT( t1.client_id ) FROM client AS t1 INNER JOIN district AS t2 ON t1.district_id = t2.district_id WHERE t1.gender = 'F' GROUP BY t2.district_id, t2.a2 ORDER BY COUNT( t1.client_id ) DESC NULLS LAST LIMIT 9;	SELECT `t2`.`a2` , COUNT( `t1`.`client_id` ) FROM `client` AS `t1` INNER JOIN `district` AS `t2` ON `t1`.`district_id` = `t2`.`district_id` WHERE `t1`.`gender` = 'F' GROUP BY `t2`.`district_id` , `t2`.`a2` ORDER BY COUNT(`t1`.`client_id`) DESC LIMIT 9
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 9' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 9' at line 1")	√
SELECT "t2"."milliseconds" , "t1"."forename" , "t1"."surname" , "t3"."name" FROM "drivers" AS "t1" INNER JOIN "laptimes" AS "t2" ON "t1"."driverid" = "t2"."driverid" INNER JOIN "races" AS "t3" ON "t2"."raceid" = "t3"."raceid" ORDER BY "t2"."milliseconds" ASC NULLS FIRST LIMIT 1	SELECT `t2`.`milliseconds`, `t1`.`forename`, `t1`.`surname`, `t3`.`name` FROM `drivers` AS `t1` INNER JOIN `laptimes` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t2`.`raceid` = `t3`.`raceid` ORDER BY `t2`.`milliseconds` ASC LIMIT 1	SELECT `t2`.`milliseconds` , `t1`.`forename` , `t1`.`surname` , `t3`.`name` FROM `drivers` AS `t1` INNER JOIN `laptimes` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t2`.`raceid` = `t3`.`raceid` ORDER BY `t2`.`milliseconds` ASC LIMIT 1	SELECT t2.milliseconds , t1.forename , t1.surname , t3.name FROM drivers AS t1 INNER JOIN laptimes AS t2 ON t1.driverid = t2.driverid INNER JOIN races AS t3 ON t2.raceid = t3.raceid ORDER BY t2.milliseconds ASC NULLS FIRST LIMIT 1	SELECT t2.milliseconds, t1.forename, t1.surname, t3.name FROM drivers AS t1 INNER JOIN laptimes AS t2 ON t1.driverid = t2.driverid INNER JOIN races AS t3 ON t2.raceid = t3.raceid ORDER BY t2.milliseconds ASC LIMIT 1	SELECT `t2`.`milliseconds`, `t1`.`forename`, `t1`.`surname`, `t3`.`name` FROM `drivers` AS `t1` INNER JOIN `laptimes` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t2`.`raceid` = `t3`.`raceid` ORDER BY `t2`.`milliseconds` ASC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1' at line 1")	√	√
SELECT "nationality" FROM "drivers" WHERE NOT "dob" IS NULL ORDER BY "dob" ASC NULLS FIRST LIMIT 1	SELECT `nationality` FROM `drivers` WHERE NOT `dob` IS NULL ORDER BY `dob` ASC LIMIT 1	SELECT `nationality` FROM `drivers` WHERE NOT `dob` IS NULL ORDER BY `dob` ASC LIMIT 1	SELECT nationality FROM drivers WHERE NOT dob IS NULL ORDER BY dob ASC NULLS FIRST LIMIT 1	SELECT `nationality` FROM `drivers` WHERE `dob` IS NOT NULL ORDER BY `dob` ASC LIMIT 1	SELECT `nationality` FROM `drivers` WHERE NOT `dob` IS NULL ORDER BY `dob` IS NULL, `dob` ASC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1' at line 1")	√	√
SELECT "t2"."driverid" , "t2"."code" FROM "results" AS "t1" INNER JOIN "drivers" AS "t2" ON "t1"."driverid" = "t2"."driverid" WHERE TO_CHAR( CAST( "t2"."dob" AS TIMESTAMP ) , 'YYYY' ) = '1971' AND NOT "t1"."fastestlaptime" IS NULL	SELECT `t2`.`driverid`, `t2`.`code` FROM `results` AS `t1` INNER JOIN `drivers` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` WHERE DATE_FORMAT(CAST(`t2`.`dob` AS DATETIME), '%Y') = '1971' AND NOT `t1`.`fastestlaptime` IS NULL	SELECT `t2`.`driverid` , `t2`.`code` FROM `results` AS `t1` INNER JOIN `drivers` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` WHERE DATE_FORMAT( CAST( `t2`.`dob` AS DATETIME ) , '%Y' ) = '1971' AND NOT `t1`.`fastestlaptime` IS NULL	SELECT t2.driverid , t2.code FROM results AS t1 INNER JOIN drivers AS t2 ON t1.driverid = t2.driverid WHERE DATE_FORMAT( CAST( t2.dob AS DATETIME ) , '%Y' ) = '1971' AND NOT t1.fastestlaptime IS NULL ;	SELECT t2.driverid, t2.code FROM results AS t1 INNER JOIN drivers AS t2 ON t1.driverid = t2.driverid WHERE YEAR(CAST(t2.dob AS DATE)) = 1971 AND t1.fastestlaptime IS NOT NULL;	SELECT `t2`.`driverid` , `t2`.`code` FROM `results` AS `t1` INNER JOIN `drivers` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` WHERE CAST(`t2`.`dob` AS DATE) LIKE '1971%' AND NOT `t1`.`fastestlaptime` IS NULL
Source Dialect	√	√	√	√	√
SELECT "t2"."event_name" FROM "budget" AS "t1" INNER JOIN "event" AS "t2" ON "t2"."event_id" = "t1"."link_to_event" WHERE "t1"."event_status" = 'Closed' AND "t1"."remaining" < 0 ORDER BY "t1"."remaining" NULLS FIRST LIMIT 1	SELECT `t2`.`event_name` FROM `budget` AS `t1` INNER JOIN `event` AS `t2` ON `t2`.`event_id` = `t1`.`link_to_event` WHERE `t1`.`event_status` = 'Closed' AND `t1`.`remaining` < 0 ORDER BY `t1`.`remaining` LIMIT 1	SELECT `t2`.`event_name` FROM `budget` AS `t1` INNER JOIN `event` AS `t2` ON `t2`.`event_id` = `t1`.`link_to_event` WHERE `t1`.`event_status` = 'Closed' AND `t1`.`remaining` < 0 ORDER BY `t1`.`remaining` LIMIT 1	SELECT t2.event_name FROM budget AS t1 INNER JOIN event AS t2 ON t2.event_id = t1.link_to_event WHERE t1.event_status = 'Closed' AND t1.remaining < 0 ORDER BY t1.remaining NULLS FIRST LIMIT 1	SELECT t2.event_name FROM budget AS t1 INNER JOIN event AS t2 ON t2.event_id = t1.link_to_event WHERE t1.event_status = 'Closed' AND t1.remaining < 0 ORDER BY t1.remaining NULLS FIRST LIMIT 1;	SELECT `t2`.`event_name` FROM `budget` AS `t1` INNER JOIN `event` AS `t2` ON `t2`.`event_id` = `t1`.`link_to_event` WHERE `t1`.`event_status` = 'Closed' AND `t1`.`remaining` < 0 ORDER BY `t1`.`remaining` ASC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS FIRST LIMIT 1' at line 1")	√
SELECT CAST( SUM( CASE WHEN "sex" = 'F' THEN 1 ELSE 0 END ) AS REAL ) * 100 / NULLIF( COUNT( "id" ) , 0 ) FROM "patient" WHERE "diagnosis" = 'RA' AND TO_CHAR( CAST( "birthday" AS TIMESTAMP ) , 'YYYY' ) = '1980'	SELECT CAST(SUM(CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END) AS FLOAT) * 100 / NULLIF(COUNT(`id`), 0) FROM `patient` WHERE `diagnosis` = 'RA' AND DATE_FORMAT(CAST(`birthday` AS DATETIME), '%Y') = '1980'	SELECT CAST( SUM( CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END ) AS DOUBLE ) * 100 / COUNT( `id` ) FROM `patient` WHERE `diagnosis` = 'RA' AND DATE_FORMAT( CAST( `birthday` AS DATETIME ) , '%Y' ) = '1980'	SELECT CAST( SUM( CASE WHEN sex = 'F' THEN 1 ELSE 0 END ) AS REAL ) * 100 / NULLIF( COUNT( id ) , 0 ) FROM patient WHERE diagnosis = 'RA' AND DATE_FORMAT( CAST( birthday AS DATETIME ) , '%Y' ) = '1980' ;	SELECT CAST( SUM( CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END ) AS REAL ) * 100 / NULLIF( COUNT( `id` ), 0 ) FROM `patient` WHERE `diagnosis` = 'RA' AND YEAR( `birthday` ) = 1980	SELECT CAST( SUM( CASE WHEN `sex` = 'F' THEN 1 ELSE 0 END ) AS REAL ) * 100 / NULLIF( COUNT( `id` ) , 0 ) FROM `patient` WHERE `diagnosis` = 'RA' AND YEAR(CAST(`birthday` AS DATE)) = 1980
Source Dialect	√	√	√	√	√
SELECT COUNT( DISTINCT "t1"."id" ) FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."cre" >= 1.5 AND EXTRACT( YEAR FROM AGE( CURRENT_DATE , "t1"."birthday" ) ) < 70	SELECT COUNT(DISTINCT `t1`.`id`) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`cre` >= 1.5 AND EXTRACT(YEAR FROM AGE(CURRENT_DATE, `t1`.`birthday`)) < 70	SELECT COUNT( DISTINCT `t1`.`id` ) FROM `patient` AS `t1` INNER JOIN `laboratory` AS `t2` ON `t1`.`id` = `t2`.`id` WHERE `t2`.`cre` >= 1.5 AND YEAR( CURDATE( ) ) - YEAR( `t1`.`birthday` ) < 70	SELECT COUNT( DISTINCT t1.id ) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.cre >= 1.5 AND YEAR( AGE( CURRENT_DATE , t1.birthday ) ) < 70	SELECT COUNT(DISTINCT t2.id) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.cre >= 1.5 AND YEAR(CURDATE() - t1.birthday) < 70	SELECT COUNT(DISTINCT t2.id) FROM patient AS t1 INNER JOIN laboratory AS t2 ON t1.id = t2.id WHERE t2.cre >= 1.5 AND YEAR(CURDATE() - t1.birthday) < 70
Source Dialect	(1305, 'FUNCTION xxxx_BIRD.AGE does not exist')	(1065, 'Query was empty')	(1305, 'FUNCTION xxxx_BIRD.AGE does not exist')	√	√
SELECT "t2"."forename" , "t2"."surname" FROM "qualifying" AS "t1" INNER JOIN "drivers" AS "t2" ON "t1"."driverid" = "t2"."driverid" INNER JOIN "races" AS "t3" ON "t1"."raceid" = "t3"."raceid" WHERE "q3" IS NOT NULL AND "t3"."year" = 2008 AND "t3"."circuitid" IN ( SELECT "circuitid" FROM "circuits" WHERE "name" = 'Marina Bay Street Circuit' ) ORDER BY CAST( SPLIT_PART( "q3" , ':' , 1 ) AS INTEGER ) * 60 + CAST( SPLIT_PART( SPLIT_PART( "q3" , ':' , 2 ) , '.' , 1 ) AS REAL ) + CAST( SPLIT_PART( "q3" , '.' , 2 ) AS REAL ) / 1000 ASC LIMIT 1	SELECT `t2`.`forename`, `t2`.`surname` FROM `qualifying` AS `t1` INNER JOIN `drivers` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t1`.`raceid` = `t3`.`raceid` WHERE NOT `q3` IS NULL AND `t3`.`year` = 2008 AND `t3`.`circuitid` IN (SELECT `circuitid` FROM `circuits` WHERE `name` = 'Marina Bay Street Circuit') ORDER BY CASE WHEN CAST(SPLIT_PART(`q3`, ':', 1) AS SIGNED) * 60 + CAST(SPLIT_PART(SPLIT_PART(`q3`, ':', 2), '.', 1) AS FLOAT) + CAST(SPLIT_PART(`q3`, '.', 2) AS FLOAT) / 1000 IS NULL THEN 1 ELSE 0 END, CAST(SPLIT_PART(`q3`, ':', 1) AS SIGNED) * 60 + CAST(SPLIT_PART(SPLIT_PART(`q3`, ':', 2), '.', 1) AS FLOAT) + CAST(SPLIT_PART(`q3`, '.', 2) AS FLOAT) / 1000 ASC LIMIT 1	SELECT `t2`.`forename` , `t2`.`surname` FROM `qualifying` AS `t1` INNER JOIN `drivers` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t1`.`raceid` = `t3`.`raceid` WHERE NOT `q3` IS NULL AND `t3`.`year` = 2008 AND `t3`.`circuitid` IN ( SELECT `circuitid` FROM `circuits` WHERE `name` = 'Marina Bay Street Circuit' ) ORDER BY CAST( SUBSTR( `q3` , 1 , INSTR( `q3` , ':' ) - 1 ) AS SIGNED ) * 60 + CAST( SUBSTR( `q3` , INSTR( `q3` , ':' ) + 1 , INSTR( `q3` , '.' ) - INSTR( `q3` , ':' ) - 1 ) AS DOUBLE ) + CAST( SUBSTR( `q3` , INSTR( `q3` , '.' ) + 1 ) AS DOUBLE ) / 1000 ASC LIMIT 1	SELECT t2.forename , t2.surname FROM qualifying AS t1 INNER JOIN drivers AS t2 ON t1.driverid = t2.driverid INNER JOIN races AS t3 ON t1.raceid = t3.raceid WHERE q3 IS NOT NULL AND t3.year = 2008 AND t3.circuitid IN ( SELECT circuitid FROM circuits WHERE name = 'Marina Bay Street Circuit' ) ORDER BY CAST( SPLIT_PART( q3 , ':' , 1 ) AS INTEGER ) * 60 + CAST( SPLIT_PART( SPLIT_PART( q3 , ':' , 2 ) , '.' , 1 ) AS REAL ) + CAST( SPLIT_PART( q3 , '.' , 2 ) AS REAL ) / 1000 ASC LIMIT 1	Answer not returned in the given format!	SELECT `t2`.`forename` , `t2`.`surname` FROM `qualifying` AS `t1` INNER JOIN `drivers` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t1`.`raceid` = `t3`.`raceid` WHERE `q3` IS NOT NULL AND `t3`.`year` = 2008 AND `t3`.`circuitid` IN ( SELECT `circuitid` FROM `circuits` WHERE `name` = 'Marina Bay Street Circuit' ) ORDER BY SUBSTRING_INDEX(`q3`, ':', 1) + 0 * 60 + CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`q3`, ':', 2), '.', 1) AS REAL ) + CAST( SUBSTRING_INDEX(`q3`, '.', 2) AS REAL ) / 1000 ASC LIMIT 1
Source Dialect	(1305, 'FUNCTION xxxx_BIRD.SPLIT_PART does not exist')	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER ) * 60 + CAST( SPLIT_PART( SPLIT_PART( q3 , ':' , 2 ) , '.' , 1 ) AS REA' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Answer not returned in the given format!' at line 1")	√
SELECT "t1"."forename" , "t1"."surname" , "t1"."nationality" , "t3"."name" FROM "drivers" AS "t1" INNER JOIN "driverstandings" AS "t2" ON "t1"."driverid" = "t2"."driverid" INNER JOIN "races" AS "t3" ON "t2"."raceid" = "t3"."raceid" WHERE "t1"."dob" notnull ORDER BY "t1"."dob" DESC LIMIT 1	SELECT `t1`.`forename`, `t1`.`surname`, `t1`.`nationality`, `t3`.`name` FROM `drivers` AS `t1` INNER JOIN `driverstandings` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t2`.`raceid` = `t3`.`raceid` WHERE NOT `t1`.`dob` IS NULL ORDER BY CASE WHEN `t1`.`dob` IS NULL THEN 1 ELSE 0 END DESC, `t1`.`dob` DESC LIMIT 1	SELECT `t1`.`forename` , `t1`.`surname` , `t1`.`nationality` , `t3`.`name` FROM `drivers` AS `t1` INNER JOIN `driverstandings` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t2`.`raceid` = `t3`.`raceid` ORDER BY `t1`.`dob` DESC LIMIT 1	SELECT t1.forename , t1.surname , t1.nationality , t3.name FROM drivers AS t1 INNER JOIN driverstandings AS t2 ON t1.driverid = t2.driverid INNER JOIN races AS t3 ON t2.raceid = t3.raceid WHERE t1.dob notnull ORDER BY t1.dob DESC LIMIT 1	SELECT t1.forename, t1.surname, t1.nationality, t3.name FROM drivers AS t1 INNER JOIN driverstandings AS t2 ON t1.driverid = t2.driverid INNER JOIN races AS t3 ON t2.raceid = t3.raceid WHERE t1.dob IS NOT NULL ORDER BY t1.dob DESC LIMIT 1	SELECT `t1`.`forename` , `t1`.`surname` , `t1`.`nationality` , `t3`.`name` FROM `drivers` AS `t1` INNER JOIN `driverstandings` AS `t2` ON `t1`.`driverid` = `t2`.`driverid` INNER JOIN `races` AS `t3` ON `t2`.`raceid` = `t3`.`raceid` WHERE `t1`.`dob` IS NOT NULL ORDER BY `t1`.`dob` DESC LIMIT 1
Source Dialect	√	(1065, 'Query was empty')	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'notnull ORDER BY t1.dob DESC LIMIT 1' at line 1")	√	√
SELECT COUNT( "t1"."driverid" ) FROM "results" AS "t1" INNER JOIN "races" AS "t2" ON "t1"."raceid" = "t2"."raceid" INNER JOIN "status" AS "t3" ON "t1"."statusid" = "t3"."statusid" WHERE "t3"."statusid" = 3 AND "t2"."name" = 'Canadian Grand Prix' GROUP BY "t1"."driverid" ORDER BY COUNT( "t1"."driverid" ) DESC NULLS LAST LIMIT 1	SELECT COUNT(`t1`.`driverid`) FROM `results` AS `t1` INNER JOIN `races` AS `t2` ON `t1`.`raceid` = `t2`.`raceid` INNER JOIN `status` AS `t3` ON `t1`.`statusid` = `t3`.`statusid` WHERE `t3`.`statusid` = 3 AND `t2`.`name` = 'Canadian Grand Prix' GROUP BY `t1`.`driverid` ORDER BY COUNT(`t1`.`driverid`) DESC LIMIT 1	SELECT COUNT( `t1`.`driverid` ) FROM `results` AS `t1` INNER JOIN `races` AS `t2` ON `t1`.`raceid` = `t2`.`raceid` INNER JOIN `status` AS `t3` ON `t1`.`statusid` = `t3`.`statusid` WHERE `t3`.`statusid` = 3 AND `t2`.`name` = 'Canadian Grand Prix' GROUP BY `t1`.`driverid` ORDER BY COUNT( `t1`.`driverid` ) DESC LIMIT 1	SELECT COUNT( t1.driverid ) FROM results AS t1 INNER JOIN races AS t2 ON t1.raceid = t2.raceid INNER JOIN status AS t3 ON t1.statusid = t3.statusid WHERE t3.statusid = 3 AND t2.name = 'Canadian Grand Prix' GROUP BY t1.driverid ORDER BY COUNT( t1.driverid ) DESC NULLS LAST LIMIT 1	SELECT COUNT(`t1`.`driverid`) FROM `results` AS `t1` INNER JOIN `races` AS `t2` ON `t1`.`raceid` = `t2`.`raceid` INNER JOIN `status` AS `t3` ON `t1`.`statusid` = `t3`.`statusid` WHERE `t3`.`statusid` = 3 AND `t2`.`name` = 'Canadian Grand Prix' GROUP BY `t1`.`driverid` ORDER BY COUNT(`t1`.`driverid`) DESC NULLS LAST LIMIT 1;	SELECT COUNT( `t1`.`driverid` ) FROM `results` AS `t1` INNER JOIN `races` AS `t2` ON `t1`.`raceid` = `t2`.`raceid` INNER JOIN `status` AS `t3` ON `t1`.`statusid` = `t3`.`statusid` WHERE `t3`.`statusid` = 3 AND `t2`.`name` = 'Canadian Grand Prix' GROUP BY `t1`.`driverid` ORDER BY COUNT(`t1`.`driverid`) DESC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 1' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 1' at line 1")	√
SELECT "t2"."name" FROM "match" AS "t1" INNER JOIN "league" AS "t2" ON "t1"."league_id" = "t2"."id" WHERE "t1"."season" = '2015/2016' GROUP BY "t2"."name" ORDER BY SUM( "t1"."home_team_goal" + "t1"."away_team_goal" ) DESC NULLS LAST LIMIT 1	SELECT `t2`.`name` FROM `match` AS `t1` INNER JOIN `league` AS `t2` ON `t1`.`league_id` = `t2`.`id` WHERE `t1`.`season` = '2015/2016' GROUP BY `t2`.`name` ORDER BY SUM(`t1`.`home_team_goal` + `t1`.`away_team_goal`) DESC LIMIT 1	SELECT `t2`.`name` FROM `match` AS `t1` INNER JOIN `league` AS `t2` ON `t1`.`league_id` = `t2`.`id` WHERE `t1`.`season` = '2015/2016' GROUP BY `t2`.`name` ORDER BY SUM( `t1`.`home_team_goal` + `t1`.`away_team_goal` ) DESC LIMIT 1	SELECT t2.name FROM match AS t1 INNER JOIN league AS t2 ON t1.league_id = t2.id WHERE t1.season = '2015/2016' GROUP BY t2.name ORDER BY SUM( t1.home_team_goal + t1.away_team_goal ) DESC NULLS LAST LIMIT 1	SELECT t2.`name` FROM `match` AS t1 INNER JOIN `league` AS t2 ON t1.`league_id` = t2.`id` WHERE t1.`season` = '2015/2016' GROUP BY t2.`name` ORDER BY SUM( t1.`home_team_goal` + t1.`away_team_goal` ) DESC NULLS LAST LIMIT 1;	SELECT `t2`.`name` FROM `match` AS `t1` INNER JOIN `league` AS `t2` ON `t1`.`league_id` = `t2`.`id` WHERE `t1`.`season` = '2015/2016' GROUP BY `t2`.`name` ORDER BY SUM(`t1`.`home_team_goal` + `t1`.`away_team_goal`) DESC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match AS t1 INNER JOIN league AS t2 ON t1.league_id = t2.id WHERE t1.season = '2' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 1' at line 1")	√
SELECT "t2"."name" FROM "match" AS "t1" INNER JOIN "league" AS "t2" ON "t1"."league_id" = "t2"."id" WHERE "t1"."season" = '2015/2016' AND "t1"."home_team_goal" = "t1"."away_team_goal" GROUP BY "t2"."name" ORDER BY COUNT( "t1"."id" ) DESC NULLS LAST LIMIT 1	SELECT `t2`.`name` FROM `match` AS `t1` INNER JOIN `league` AS `t2` ON `t1`.`league_id` = `t2`.`id` WHERE `t1`.`season` = '2015/2016' AND `t1`.`home_team_goal` = `t1`.`away_team_goal` GROUP BY `t2`.`name` ORDER BY COUNT(`t1`.`id`) DESC LIMIT 1	SELECT `t2`.`name` FROM `match` AS `t1` INNER JOIN `league` AS `t2` ON `t1`.`league_id` = `t2`.`id` WHERE `t1`.`season` = '2015/2016' AND `t1`.`home_team_goal` = `t1`.`away_team_goal` GROUP BY `t2`.`name` ORDER BY COUNT( `t1`.`id` ) DESC LIMIT 1	SELECT t2.name FROM match AS t1 INNER JOIN league AS t2 ON t1.league_id = t2.id WHERE t1.season = '2015/2016' AND t1.home_team_goal = t1.away_team_goal GROUP BY t2.name ORDER BY COUNT( t1.id ) DESC NULLS LAST LIMIT 1	SELECT t2.`name` FROM `match` AS t1 INNER JOIN `league` AS t2 ON t1.`league_id` = t2.`id` WHERE t1.`season` = '2015/2016' AND t1.`home_team_goal` = t1.`away_team_goal` GROUP BY t2.`name` ORDER BY COUNT( t1.`id` ) DESC NULLS LAST LIMIT 1;	SELECT `t2`.`name` FROM `match` AS `t1` INNER JOIN `league` AS `t2` ON `t1`.`league_id` = `t2`.`id` WHERE `t1`.`season` = '2015/2016' AND `t1`.`home_team_goal` = `t1`.`away_team_goal` GROUP BY `t2`.`name` ORDER BY COUNT(`t1`.`id`) DESC LIMIT 1
Source Dialect	√	√	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match AS t1 INNER JOIN league AS t2 ON t1.league_id = t2.id WHERE t1.season = '2' at line 1")	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULLS LAST LIMIT 1' at line 1")	√
SELECT DISTINCT EXTRACT( YEAR FROM AGE( NOW( ) , "t2"."birthday" :: timestamp ) ) + ( CASE WHEN EXTRACT( MONTH FROM AGE( NOW( ) , "t2"."birthday" :: timestamp ) ) > 0 OR EXTRACT( DAY FROM AGE( NOW( ) , "t2"."birthday" :: timestamp ) ) > 0 THEN 1 ELSE 0 END ) AS "age" FROM "player_attributes" AS "t1" INNER JOIN "player" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id" WHERE EXTRACT( YEAR FROM "t1"."date" :: date ) BETWEEN 2013 AND 2015 AND "t1"."sprint_speed" >= 97	SELECT DISTINCT EXTRACT(YEAR FROM AGE(CURRENT_TIMESTAMP(), CAST(`t2`.`birthday` AS DATETIME))) + (CASE WHEN EXTRACT(MONTH FROM AGE(CURRENT_TIMESTAMP(), CAST(`t2`.`birthday` AS DATETIME))) > 0 OR EXTRACT(DAY FROM AGE(CURRENT_TIMESTAMP(), CAST(`t2`.`birthday` AS DATETIME))) > 0 THEN 1 ELSE 0 END) AS `age` FROM `player_attributes` AS `t1` INNER JOIN `player` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE EXTRACT(YEAR FROM CAST(`t1`.`date` AS DATE)) BETWEEN 2013 AND 2015 AND `t1`.`sprint_speed` >= 97	SELECT DISTINCT YEAR( CURDATE( ) ) - YEAR( `t2`.`birthday` ) AS `age` FROM `player_attributes` AS `t1` INNER JOIN `player` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE YEAR( `t1`.`date` ) BETWEEN 2013 AND 2015 AND `t1`.`sprint_speed` >= 97	SELECT DISTINCT YEAR( AGE( NOW( ) , t2.birthday :: datetime ) ) + ( CASE WHEN MONTH( AGE( NOW( ) , t2.birthday :: datetime ) ) > 0 OR DAY( AGE( NOW( ) , t2.birthday :: datetime ) ) > 0 THEN 1 ELSE 0 END ) AS age FROM player_attributes AS t1 INNER JOIN player AS t2 ON t1.player_api_id = t2.player_api_id WHERE YEAR( t1.date :: date ) BETWEEN 2013 AND 2015 AND t1.sprint_speed >= 97	SELECT DISTINCT EXTRACT(YEAR FROM TIMESTAMPDIFF(YEAR, TIMESTAMP('now'), `t2`.`birthday`)) + (CASE WHEN EXTRACT(MONTH FROM TIMESTAMPDIFF(MONTH, TIMESTAMP('now'), `t2`.`birthday`)) > 0 OR EXTRACT(DAY FROM TIMESTAMPDIFF(DAY, TIMESTAMP('now'), `t2`.`birthday`)) > 0 THEN 1 ELSE 0 END) AS `age` FROM `player_attributes` AS `t1` INNER JOIN `player` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE EXTRACT(YEAR FROM `t1`.`date`) BETWEEN 2013 AND 2015 AND `t1`.`sprint_speed` >= 97;	SELECT DISTINCT EXTRACT(YEAR FROM TIMESTAMPDIFF(YEAR, TIMESTAMP('now'), `t2`.`birthday`)) + (CASE WHEN EXTRACT(MONTH FROM TIMESTAMPDIFF(MONTH, TIMESTAMP('now'), `t2`.`birthday`)) > 0 OR EXTRACT(DAY FROM TIMESTAMPDIFF(DAY, TIMESTAMP('now'), `t2`.`birthday`)) > 0 THEN 1 ELSE 0 END) AS `age` FROM `player_attributes` AS `t1` INNER JOIN `player` AS `t2` ON `t1`.`player_api_id` = `t2`.`player_api_id` WHERE EXTRACT(YEAR FROM `t1`.`date`) BETWEEN 2013 AND 2015 AND `t1`.`sprint_speed` >= 97;
Source Dialect	(1305, 'FUNCTION xxxx_BIRD.AGE does not exist')	(1065, 'Query was empty')	(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':: datetime ) ) + ( CASE WHEN MONTH( AGE( NOW( ) , t2.birthday :: datetime ) ) >' at line 1")	√	√

PostgreSQL	SQLGlot	jOOQ	SQLines	GPT-4o	CrackSQL
SELECT "t1"."customerid" FROM "customers" AS "t1" INNER JOIN "yearmonth" AS "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM' AND SUBSTR( "t2"."date" , 1 , 4 ) = '2012' GROUP BY "t1"."customerid" ORDER BY SUM( "t2"."consumption" ) ASC NULLS FIRST	SELECT "t1"."customerid" FROM "customers" "t1" INNER JOIN "yearmonth" "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM' AND SUBSTR("t2"."date", 1, 4) = '2012' GROUP BY "t1"."customerid" ORDER BY SUM("t2"."consumption") ASC NULLS FIRST	select "t1"."customerid" from "customers" "t1" join "yearmonth" "t2" on "t1"."customerid" = "t2"."customerid" where ( "t1"."segment" = 'LAM' and substr("t2"."date", 1, 4) = '2012' ) group by "t1"."customerid" order by sum("t2"."consumption") asc nulls first	SELECT "t1"."customerid" FROM "customers" "t1" INNER JOIN "yearmonth" "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM' AND SUBSTR( "t2"."date" , 1 , 4 ) = '2012' GROUP BY "t1"."customerid" ORDER BY SUM( "t2"."consumption" ) ASC NULLS FIRST ;	SELECT "t1"."customerid" FROM "customers" "t1" INNER JOIN "yearmonth" "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM' AND SUBSTR( "t2"."date" , 1 , 4 ) = '2012' GROUP BY "t1"."customerid" ORDER BY SUM( "t2"."consumption" ) ASC NULLS FIRST	SELECT "t1"."customerid" FROM "customers" "t1" INNER JOIN "yearmonth" "t2" ON "t1"."customerid" = "t2"."customerid" WHERE "t1"."segment" = 'LAM' AND SUBSTR( "t2"."date" , 1 , 4 ) = '2012' GROUP BY "t1"."customerid" ORDER BY SUM( "t2"."consumption" ) ASC NULLS FIRST
Source Dialect	√	√	√	√	√
SELECT "t1"."date" , EXTRACT( YEAR FROM "t2"."first date" ) - EXTRACT( YEAR FROM "t2"."birthday" ) AS "age" , "t2"."birthday" FROM "laboratory" AS "t1" INNER JOIN "patient" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."diagnosis" = 'SJS' AND "t2"."birthday" IS NOT NULL ORDER BY "t2"."birthday" ASC	SELECT "t1"."date", EXTRACT(YEAR FROM "t2"."first date") - EXTRACT(YEAR FROM "t2"."birthday") AS "age", "t2"."birthday" FROM "laboratory" "t1" INNER JOIN "patient" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."diagnosis" = 'SJS' AND NOT "t2"."birthday" IS NULL ORDER BY "t2"."birthday" ASC	select "t1"."date", (extract(year from "t2"."first date") - extract(year from "t2"."birthday")) "age", "t2"."birthday" from "laboratory" "t1" join "patient" "t2" on "t1"."id" = "t2"."id" where ( "t2"."diagnosis" = 'SJS' and "t2"."birthday" is not null ) order by "t2"."birthday" asc	SELECT t1.date , EXTRACT( YEAR FROM t2.first "date" FROM dual ) - EXTRACT( YEAR FROM t2.birthday ) age , t2.birthday FROM laboratory t1 INNER JOIN patient t2 ON t1.id = t2.id WHERE t2.diagnosis = 'SJS' AND t2.birthday IS NOT NULL ORDER BY t2.birthday ASC	SELECT "t1"."date" , EXTRACT( YEAR FROM "t2"."first date" ) - EXTRACT( YEAR FROM "t2"."birthday" ) "age" , "t2"."birthday" FROM "laboratory" "t1" INNER JOIN "patient" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."diagnosis" = 'SJS' AND "t2"."birthday" IS NOT NULL ORDER BY "t2"."birthday" ASC	SELECT "t1"."date", EXTRACT(YEAR FROM "t2"."first date") - EXTRACT(YEAR FROM "t2"."birthday") AS "age", "t2"."birthday" FROM "laboratory" "t1" INNER JOIN "patient" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."diagnosis" = 'SJS' AND "t2"."birthday" IS NOT NULL ORDER BY "t2"."birthday" ASC
Source Dialect	√	√	ORA-01747: invalid user.table.column, table.column, or column specification Help: https://docs.oracle.com/error-help/db/ora-01747/	√	√
SELECT EXTRACT( YEAR FROM "t2"."date" ) - EXTRACT( YEAR FROM "t1"."birthday" ) AS "age_difference" , "t1"."diagnosis" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."hgb" IS NOT NULL ORDER BY "t2"."hgb" DESC	SELECT EXTRACT(YEAR FROM "t2"."date") - EXTRACT(YEAR FROM "t1"."birthday") AS "age_difference", "t1"."diagnosis" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE NOT "t2"."hgb" IS NULL ORDER BY "t2"."hgb" DESC	select (extract(year from "t2"."date") - extract(year from "t1"."birthday")) "age_difference", "t1"."diagnosis" from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where "t2"."hgb" is not null order by "t2"."hgb" desc	SELECT EXTRACT( YEAR FROM "t2"."date" ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age_difference" , "t1"."diagnosis" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."hgb" IS NOT NULL ORDER BY "t2"."hgb" DESC ;	SELECT EXTRACT( YEAR FROM "t2"."date" ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age_difference" , "t1"."diagnosis" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."hgb" IS NOT NULL ORDER BY "t2"."hgb" DESC	SELECT EXTRACT(YEAR FROM "t2"."date") - EXTRACT(YEAR FROM "t1"."birthday") AS "age_difference", "t1"."diagnosis" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."hgb" IS NOT NULL ORDER BY "t2"."hgb" DESC
Source Dialect	√	√	Inconsistent Result	√	√
SELECT CASE WHEN ( "t1"."sex" = 'F' AND "t2"."ua" > 6.5 ) OR ( "t1"."sex" = 'M' AND "t2"."ua" > 8.0 ) THEN TRUE ELSE FALSE END FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266	SELECT CASE WHEN ("t1"."sex" = 'F' AND "t2"."ua" > 6.5) OR ("t1"."sex" = 'M' AND "t2"."ua" > 8.0) THEN TRUE ELSE FALSE END FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266	select case when ( ( "t1"."sex" = 'F' and "t2"."ua" > 6.5 ) or ( "t1"."sex" = 'M' and "t2"."ua" > 8.0 ) ) then 1 else 0 end from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where "t1"."id" = 57266	SELECT CASE WHEN ( "t1"."sex" = 'F' AND "t2"."ua" > 6.5 ) OR ( "t1"."sex" = 'M' AND "t2"."ua" > 8.0 ) THEN TRUE ELSE FALSE END FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266	SELECT CASE WHEN ( "t1"."sex" = 'F' AND "t2"."ua" > 6.5 ) OR ( "t1"."sex" = 'M' AND "t2"."ua" > 8.0 ) THEN 1 ELSE 0 END FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266 AND "t1"."sex" IN ('F', 'M')	SELECT CASE WHEN ( "t1"."sex" = 'F' AND "t2"."ua" > 6.5 ) OR ( "t1"."sex" = 'M' AND "t2"."ua" > 8.0 ) THEN 1 ELSE 0 END FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" = 57266
Source Dialect	ORA-00904: "FALSE": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	ORA-00904: "FALSE": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	√
SELECT "teaminfo"."team_long_name" FROM "league" AS "leaguedata" INNER JOIN "match" AS "matchdata" ON "leaguedata"."id" = "matchdata"."league_id" INNER JOIN "team" AS "teaminfo" ON "matchdata"."away_team_api_id" = "teaminfo"."team_api_id" WHERE "leaguedata"."name" = 'Scotland Premier League' AND "matchdata"."season" = '2009/2010' AND "matchdata"."away_team_goal" - "matchdata"."home_team_goal" > 0 GROUP BY "teaminfo"."team_long_name" , "matchdata"."away_team_api_id" ORDER BY COUNT( * ) DESC	SELECT "teaminfo"."team_long_name" FROM "league" "leaguedata" INNER JOIN "match" "matchdata" ON "leaguedata"."id" = "matchdata"."league_id" INNER JOIN "team" "teaminfo" ON "matchdata"."away_team_api_id" = "teaminfo"."team_api_id" WHERE "leaguedata"."name" = 'Scotland Premier League' AND "matchdata"."season" = '2009/2010' AND "matchdata"."away_team_goal" - "matchdata"."home_team_goal" > 0 GROUP BY "teaminfo"."team_long_name", "matchdata"."away_team_api_id" ORDER BY COUNT(*) DESC	select "teaminfo"."team_long_name" from "league" "leaguedata" join "match" "matchdata" on "leaguedata"."id" = "matchdata"."league_id" join "team" "teaminfo" on "matchdata"."away_team_api_id" = "teaminfo"."team_api_id" where ( "leaguedata"."name" = 'Scotland Premier League' and "matchdata"."season" = '2009/2010' and ("matchdata"."away_team_goal" - "matchdata"."home_team_goal") > 0 ) group by "teaminfo"."team_long_name", "matchdata"."away_team_api_id" order by count(*) desc	SELECT "teaminfo"."team_long_name" FROM "league" "leaguedata" INNER JOIN "match" "matchdata" ON "leaguedata"."id" = "matchdata"."league_id" INNER JOIN "team" "teaminfo" ON "matchdata"."away_team_api_id" = "teaminfo"."team_api_id" WHERE "leaguedata"."name" = 'Scotland Premier League' AND "matchdata"."season" = '2009/2010' AND "matchdata"."away_team_goal" - "matchdata"."home_team_goal" > 0 GROUP BY "teaminfo"."team_long_name" , "matchdata"."away_team_api_id" ORDER BY COUNT( * ) DESC ;	SELECT "teaminfo"."team_long_name" FROM "league" "leaguedata" INNER JOIN "match" "matchdata" ON "leaguedata"."id" = "matchdata"."league_id" INNER JOIN "team" "teaminfo" ON "matchdata"."away_team_api_id" = "teaminfo"."team_api_id" WHERE "leaguedata"."name" = 'Scotland Premier League' AND "matchdata"."season" = '2009/2010' AND "matchdata"."away_team_goal" - "matchdata"."home_team_goal" > 0 GROUP BY "teaminfo"."team_long_name" , "matchdata"."away_team_api_id" ORDER BY COUNT( * ) DESC	SELECT "teaminfo"."team_long_name" FROM "league" "leaguedata" INNER JOIN "match" "matchdata" ON "leaguedata"."id" = "matchdata"."league_id" INNER JOIN "team" "teaminfo" ON "matchdata"."away_team_api_id" = "teaminfo"."team_api_id" WHERE "leaguedata"."name" = 'Scotland Premier League' AND "matchdata"."season" = '2009/2010' AND "matchdata"."away_team_goal" - "matchdata"."home_team_goal" > 0 GROUP BY "teaminfo"."team_long_name", "matchdata"."away_team_api_id" ORDER BY COUNT(*) DESC
Source Dialect	√	√	√	√	√
SELECT "t2"."url" FROM "constructorresults" AS "t1" INNER JOIN "constructors" AS "t2" ON "t2"."constructorid" = "t1"."constructorid" WHERE "t1"."raceid" = 9 ORDER BY "t1"."points" DESC NULLS LAST	SELECT "t2"."url" FROM "constructorresults" "t1" INNER JOIN "constructors" "t2" ON "t2"."constructorid" = "t1"."constructorid" WHERE "t1"."raceid" = 9 ORDER BY "t1"."points" DESC NULLS LAST	select "t2"."url" from "constructorresults" "t1" join "constructors" "t2" on "t2"."constructorid" = "t1"."constructorid" where "t1"."raceid" = 9 order by "t1"."points" desc nulls last	SELECT "t2"."url" FROM "constructorresults" "t1" INNER JOIN "constructors" "t2" ON "t2"."constructorid" = "t1"."constructorid" WHERE "t1"."raceid" = 9 ORDER BY "t1"."points" DESC NULLS LAST ;	SELECT "t2"."url" FROM "constructorresults" "t1" INNER JOIN "constructors" "t2" ON "t2"."constructorid" = "t1"."constructorid" WHERE "t1"."raceid" = 9 ORDER BY "t1"."points" DESC NULLS LAST	SELECT "t2"."url" FROM "constructorresults" "t1" INNER JOIN "constructors" "t2" ON "t2"."constructorid" = "t1"."constructorid" WHERE "t1"."raceid" = 9 ORDER BY "t1"."points" DESC NULLS LAST
Source Dialect	√	√	√	√	√
SELECT "t1"."forename" , "t1"."surname" , "t1"."nationality" , MAX( "t2"."points" ) FROM "drivers" AS "t1" INNER JOIN "driverstandings" AS "t2" ON "t2"."driverid" = "t1"."driverid" WHERE "t2"."wins" >= 1 GROUP BY "t1"."forename" , "t1"."surname" , "t1"."nationality" ORDER BY COUNT( "t2"."wins" ) DESC NULLS LAST	SELECT "t1"."forename", "t1"."surname", "t1"."nationality", MAX("t2"."points") FROM "drivers" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."driverid" = "t1"."driverid" WHERE "t2"."wins" >= 1 GROUP BY "t1"."forename", "t1"."surname", "t1"."nationality" ORDER BY COUNT("t2"."wins") DESC NULLS LAST	select "t1"."forename", "t1"."surname", "t1"."nationality", max("t2"."points") from "drivers" "t1" join "driverstandings" "t2" on "t2"."driverid" = "t1"."driverid" where "t2"."wins" >= 1 group by "t1"."forename", "t1"."surname", "t1"."nationality" order by count("t2"."wins") desc nulls last	SELECT "t1"."forename" , "t1"."surname" , "t1"."nationality" , MAX( "t2"."points" ) FROM "drivers" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."driverid" = "t1"."driverid" WHERE "t2"."wins" >= 1 GROUP BY "t1"."forename" , "t1"."surname" , "t1"."nationality" ORDER BY COUNT( "t2"."wins" ) DESC NULLS LAST ;	SELECT "t1"."forename" , "t1"."surname" , "t1"."nationality" , MAX( "t2"."points" ) FROM "drivers" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."driverid" = "t1"."driverid" WHERE "t2"."wins" >= 1 GROUP BY "t1"."forename" , "t1"."surname" , "t1"."nationality" ORDER BY COUNT( "t2"."wins" ) DESC NULLS LAST	SELECT "t1"."forename" , "t1"."surname" , "t1"."nationality" , MAX( "t2"."points" ) FROM "drivers" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."driverid" = "t1"."driverid" WHERE "t2"."wins" >= 1 GROUP BY "t1"."forename" , "t1"."surname" , "t1"."nationality" ORDER BY COUNT( "t2"."wins" ) DESC NULLS LAST
Source Dialect	√	√	√	√	√
SELECT "t1"."name" , "t1"."year" FROM "races" AS "t1" INNER JOIN "laptimes" AS "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" AS "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Michael' AND "t3"."surname" = 'Schumacher' ORDER BY "t2"."milliseconds" ASC NULLS FIRST	SELECT "t1"."name", "t1"."year" FROM "races" "t1" INNER JOIN "laptimes" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Michael' AND "t3"."surname" = 'Schumacher' ORDER BY "t2"."milliseconds" ASC NULLS FIRST	select "t1"."name", "t1"."year" from "races" "t1" join "laptimes" "t2" on "t2"."raceid" = "t1"."raceid" join "drivers" "t3" on "t3"."driverid" = "t2"."driverid" where ( "t3"."forename" = 'Michael' and "t3"."surname" = 'Schumacher' ) order by "t2"."milliseconds" asc nulls first	SELECT "t1"."name" , "t1"."year" FROM "races" "t1" INNER JOIN "laptimes" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Michael' AND "t3"."surname" = 'Schumacher' ORDER BY "t2"."milliseconds" ASC NULLS FIRST ;	SELECT "t1"."name" , "t1"."year" FROM "races" "t1" INNER JOIN "laptimes" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Michael' AND "t3"."surname" = 'Schumacher' ORDER BY "t2"."milliseconds" ASC NULLS FIRST	SELECT "t1"."name", "t1"."year" FROM "races" "t1" INNER JOIN "laptimes" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Michael' AND "t3"."surname" = 'Schumacher' ORDER BY "t2"."milliseconds" ASC NULLS FIRST
Source Dialect	√	√	√	√	√
SELECT "t1"."superhero_name" FROM "superhero" AS "t1" INNER JOIN "hero_attribute" AS "t2" ON "t1"."id" = "t2"."hero_id" INNER JOIN "attribute" AS "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Speed' ORDER BY "t2"."attribute_value" DESC NULLS LAST	SELECT "t1"."superhero_name" FROM "superhero" "t1" INNER JOIN "hero_attribute" "t2" ON "t1"."id" = "t2"."hero_id" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Speed' ORDER BY "t2"."attribute_value" DESC NULLS LAST	select "t1"."superhero_name" from "superhero" "t1" join "hero_attribute" "t2" on "t1"."id" = "t2"."hero_id" join "attribute" "t3" on "t2"."attribute_id" = "t3"."id" where "t3"."attribute_name" = 'Speed' order by "t2"."attribute_value" desc nulls last	SELECT "t1"."superhero_name" FROM "superhero" "t1" INNER JOIN "hero_attribute" "t2" ON "t1"."id" = "t2"."hero_id" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Speed' ORDER BY "t2"."attribute_value" DESC NULLS LAST ;	SELECT "t1"."superhero_name" FROM "superhero" "t1" INNER JOIN "hero_attribute" "t2" ON "t1"."id" = "t2"."hero_id" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Speed' ORDER BY "t2"."attribute_value" DESC NULLS LAST	SELECT "t1"."superhero_name" FROM "superhero" "t1" INNER JOIN "hero_attribute" "t2" ON "t1"."id" = "t2"."hero_id" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Speed' ORDER BY "t2"."attribute_value" DESC
Source Dialect	√	√	√	√	√
SELECT CASE WHEN "t2"."closeddate" IS NULL THEN 'NOT well-finished' ELSE 'well-finished' END AS "resylt" FROM "comments" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."postid" = "t2"."id" WHERE "t1"."userid" = 23853 AND "t1"."creationdate" = '2013-07-12 09:08:18.0'	SELECT CASE WHEN "t2"."closeddate" IS NULL THEN 'NOT well-finished' ELSE 'well-finished' END AS "resylt" FROM "comments" "t1" INNER JOIN "posts" "t2" ON "t1"."postid" = "t2"."id" WHERE "t1"."userid" = 23853 AND "t1"."creationdate" = '2013-07-12 09:08:18.0'	select case when "t2"."closeddate" is null then 'NOT well-finished' else 'well-finished' end "resylt" from "comments" "t1" join "posts" "t2" on "t1"."postid" = "t2"."id" where ( "t1"."userid" = 23853 and "t1"."creationdate" = '2013-07-12 09:08:18.0' )	SELECT CASE WHEN "t2"."closeddate" IS NULL THEN 'NOT well-finished' ELSE 'well-finished' END resylt FROM "comments" "t1" INNER JOIN "posts" "t2" ON "t1"."postid" = "t2"."id" WHERE "t1"."userid" = 23853 AND "t1"."creationdate" = '2013-07-12 09:08:18.0'	Answer not returned in the given format!	SELECT CASE WHEN "t2"."closeddate" IS NULL THEN 'NOT well-finished' ELSE 'well-finished' END AS "resylt" FROM "comments" "t1" INNER JOIN "posts" "t2" ON "t1"."postid" = "t2"."id" WHERE "t1"."userid" = 23853 AND "t1"."creationdate" = TO_DATE('2013-07-12 09:08:18', 'YYYY-MM-DD HH24:MI:SS')
Source Dialect	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-00900: invalid SQL statement Help: https://docs.oracle.com/error-help/db/ora-00900/	√
SELECT "t2"."owneruserid" , "t1"."displayname" FROM "users" AS "t1" INNER JOIN "posts" AS "t2" ON "t1"."id" = "t2"."owneruserid" WHERE TO_CHAR( CAST( "t1"."creationdate" AS TIMESTAMP ) , 'YYYY' ) = '2010' ORDER BY "t2"."favoritecount" DESC NULLS LAST	SELECT "t2"."owneruserid", "t1"."displayname" FROM "users" "t1" INNER JOIN "posts" "t2" ON "t1"."id" = "t2"."owneruserid" WHERE TO_CHAR(CAST("t1"."creationdate" AS TIMESTAMP), 'YYYY') = '2010' ORDER BY "t2"."favoritecount" DESC NULLS LAST	select "t2"."owneruserid", "t1"."displayname" from "users" "t1" join "posts" "t2" on "t1"."id" = "t2"."owneruserid" where to_char(cast("t1"."creationdate" as timestamp), 'YYYY') = '2010' order by "t2"."favoritecount" desc nulls last	SELECT "t2"."owneruserid" , "t1"."displayname" FROM "users" "t1" INNER JOIN "posts" "t2" ON "t1"."id" = "t2"."owneruserid" WHERE TO_CHAR( CAST( "t1"."creationdate" AS TIMESTAMP ) , 'YYYY' ) = '2010' ORDER BY "t2"."favoritecount" DESC NULLS LAST ;	SELECT "t2"."owneruserid" , "t1"."displayname" FROM "users" "t1" INNER JOIN "posts" "t2" ON "t1"."id" = "t2"."owneruserid" WHERE TO_CHAR( CAST( "t1"."creationdate" AS TIMESTAMP ) , 'YYYY' ) = '2010' ORDER BY "t2"."favoritecount" DESC NULLS LAST	SELECT "t2"."owneruserid", "t1"."displayname" FROM "users" "t1" INNER JOIN "posts" "t2" ON "t1"."id" = "t2"."owneruserid" WHERE TO_CHAR("t1"."creationdate", 'YYYY') = '2010' ORDER BY "t2"."favoritecount" DESC
Source Dialect	√	√	√	√	√
SELECT "t1"."name" , "t1"."artist" , "t1"."ispromo" FROM "cards" AS "t1" INNER JOIN "rulings" AS "t2" ON "t1"."uuid" = "t2"."uuid" WHERE "t1"."ispromo" = 1 AND "t1"."artist" = ( SELECT "artist" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" HAVING COUNT( DISTINCT "uuid" ) = ( SELECT MAX( "count_uuid" ) FROM ( SELECT COUNT( DISTINCT "uuid" ) AS "count_uuid" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" ) AS "subquery" ) )	SELECT "t1"."name", "t1"."artist", "t1"."ispromo" FROM "cards" "t1" INNER JOIN "rulings" "t2" ON "t1"."uuid" = "t2"."uuid" WHERE "t1"."ispromo" = 1 AND "t1"."artist" = (SELECT "artist" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" HAVING COUNT(DISTINCT "uuid") = (SELECT MAX("count_uuid") FROM (SELECT COUNT(DISTINCT "uuid") AS "count_uuid" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist") "subquery"))	select "t1"."name", "t1"."artist", "t1"."ispromo" from "cards" "t1" join "rulings" "t2" on "t1"."uuid" = "t2"."uuid" where ( "t1"."ispromo" = 1 and "t1"."artist" = ( select "artist" from "cards" where "ispromo" = 1 group by "artist" having count(distinct "uuid") = ( select max("count_uuid") from ( select count(distinct "uuid") "count_uuid" from "cards" where "ispromo" = 1 group by "artist" ) "subquery" ) ) )	SELECT "t1"."name" , "t1"."artist" , "t1"."ispromo" FROM "cards" "t1" INNER JOIN "rulings" "t2" ON "t1"."uuid" = "t2"."uuid" WHERE "t1"."ispromo" = 1 AND "t1"."artist" = ( SELECT "artist" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" HAVING COUNT( DISTINCT "uuid" ) = ( SELECT MAX( "count_uuid" ) FROM ( SELECT COUNT( DISTINCT "uuid" ) "count_uuid" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" ) "subquery" ) ) ;	SELECT "t1"."name" , "t1"."artist" , "t1"."ispromo" FROM "cards" "t1" INNER JOIN "rulings" "t2" ON "t1"."uuid" = "t2"."uuid" WHERE "t1"."ispromo" = 1 AND "t1"."artist" = ( SELECT "artist" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" HAVING COUNT( DISTINCT "uuid" ) = ( SELECT MAX( "count_uuid" ) FROM ( SELECT COUNT( DISTINCT "uuid" ) "count_uuid" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" ) "subquery" ) )	SELECT "t1"."name", "t1"."artist", "t1"."ispromo" FROM "cards" "t1" INNER JOIN "rulings" "t2" ON "t1"."uuid" = "t2"."uuid" WHERE "t1"."ispromo" = 1 AND "t1"."artist" = ( SELECT "artist" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" HAVING COUNT( DISTINCT "uuid" ) = ( SELECT MAX( "count_uuid" ) FROM ( SELECT COUNT( DISTINCT "uuid" ) AS "count_uuid" FROM "cards" WHERE "ispromo" = 1 GROUP BY "artist" ) "subquery" ))
Source Dialect	√	√	√	√	√
SELECT "t"."element" FROM ( SELECT "t1"."element" , COUNT( DISTINCT "t1"."molecule_id" ) FROM "atom" AS "t1" INNER JOIN "molecule" AS "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '-' GROUP BY "t1"."element" ORDER BY COUNT( DISTINCT "t1"."molecule_id" ) ASC NULLS FIRST ) AS "t"	SELECT "t"."element" FROM (SELECT "t1"."element", COUNT(DISTINCT "t1"."molecule_id") FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '-' GROUP BY "t1"."element" ORDER BY COUNT(DISTINCT "t1"."molecule_id") ASC NULLS FIRST) "t"	select "t"."element" from ( select "t1"."element", count(distinct "t1"."molecule_id") from "atom" "t1" join "molecule" "t2" on "t1"."molecule_id" = "t2"."molecule_id" where "t2"."label" = '-' group by "t1"."element" order by count(distinct "t1"."molecule_id") asc nulls first ) "t"	SELECT "t"."element" FROM ( SELECT "t1"."element" , COUNT( DISTINCT "t1"."molecule_id" ) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '-' GROUP BY "t1"."element" ORDER BY COUNT( DISTINCT "t1"."molecule_id" ) ASC NULLS FIRST ) "t" ;	SELECT "t"."element" FROM ( SELECT "t1"."element" , COUNT( DISTINCT "t1"."molecule_id" ) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '-' GROUP BY "t1"."element" ORDER BY COUNT( DISTINCT "t1"."molecule_id" ) ASC NULLS FIRST ) "t"	SELECT "t"."element" FROM ( SELECT "t1"."element" , COUNT( DISTINCT "t1"."molecule_id" ) FROM "atom" "t1" INNER JOIN "molecule" "t2" ON "t1"."molecule_id" = "t2"."molecule_id" WHERE "t2"."label" = '-' GROUP BY "t1"."element" ORDER BY COUNT( DISTINCT "t1"."molecule_id" ) ASC ) "t"
Source Dialect	√	√	√	√	√
SELECT "t2"."school" , "t2"."doc" FROM "frpm" AS "t1" INNER JOIN "schools" AS "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."fundingtype" = 'Locally funded' AND ( "t1"."enrollment (k-12)" - "t1"."enrollment (ages 5-17)" ) > ( SELECT AVG( "t3"."enrollment (k-12)" - "t3"."enrollment (ages 5-17)" ) FROM "frpm" AS "t3" INNER JOIN "schools" AS "t4" ON "t3"."cdscode" = "t4"."cdscode" WHERE "t4"."fundingtype" = 'Locally funded' )	SELECT "t2"."school", "t2"."doc" FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."fundingtype" = 'Locally funded' AND ("t1"."enrollment (k-12)" - "t1"."enrollment (ages 5-17)") > (SELECT AVG("t3"."enrollment (k-12)" - "t3"."enrollment (ages 5-17)") FROM "frpm" "t3" INNER JOIN "schools" "t4" ON "t3"."cdscode" = "t4"."cdscode" WHERE "t4"."fundingtype" = 'Locally funded')	select "t2"."school", "t2"."doc" from "frpm" "t1" join "schools" "t2" on "t1"."cdscode" = "t2"."cdscode" where ( "t2"."fundingtype" = 'Locally funded' and ("t1"."enrollment (k-12)" - "t1"."enrollment (ages 5-17)") > ( select avg(("t3"."enrollment (k-12)" - "t3"."enrollment (ages 5-17)")) from "frpm" "t3" join "schools" "t4" on "t3"."cdscode" = "t4"."cdscode" where "t4"."fundingtype" = 'Locally funded' ) )	SELECT t2.school , t2.doc FROM frpm t1 INNER JOIN schools t2 ON t1.cdscode = t2.cdscode WHERE t2.fundingtype = 'Locally funded' AND ( t1.enrollment (k-12) - t1.enrollment (ages 5-17) ) > ( SELECT AVG( t3.enrollment (k-12) - t3.enrollment (ages 5 FROM dual-17) ) FROM frpm t3 INNER JOIN schools t4 ON t3.cdscode = t4.cdscode WHERE t4.fundingtype = 'Locally funded' )	SELECT "t2"."school" , "t2"."doc" FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."fundingtype" = 'Locally funded' AND ( "t1"."enrollment (k-12)" - "t1"."enrollment (ages 5-17)" ) > ( SELECT AVG( "t3"."enrollment (k-12)" - "t3"."enrollment (ages 5-17)" ) FROM "frpm" "t3" INNER JOIN "schools" "t4" ON "t3"."cdscode" = "t4"."cdscode" WHERE "t4"."fundingtype" = 'Locally funded' )	SELECT "t2"."school", "t2"."doc" FROM "frpm" "t1" INNER JOIN "schools" "t2" ON "t1"."cdscode" = "t2"."cdscode" WHERE "t2"."fundingtype" = 'Locally funded' AND ( "t1"."enrollment (k-12)" - "t1"."enrollment (ages 5-17)" ) > ( SELECT AVG( "t3"."enrollment (k-12)" - "t3"."enrollment (ages 5-17)" ) FROM "frpm" "t3" INNER JOIN "schools" "t4" ON "t3"."cdscode" = "t4"."cdscode" WHERE "t4"."fundingtype" = 'Locally funded' )
Source Dialect	√	√	ORA-00907: missing right parenthesis Help: https://docs.oracle.com/error-help/db/ora-00907/	√	√
SELECT "gsoffered" FROM "schools" ORDER BY ABS( "longitude" ) DESC NULLS LAST	SELECT "gsoffered" FROM "schools" ORDER BY ABS("longitude") DESC NULLS LAST	select "gsoffered" from "schools" order by abs("longitude") desc nulls last	SELECT "gsoffered" FROM "schools" ORDER BY ABS( "longitude" ) DESC NULLS LAST ;	SELECT "gsoffered" FROM "schools" ORDER BY ABS( "longitude" ) DESC NULLS LAST	SELECT "gsoffered" FROM "schools" ORDER BY ABS( "longitude" ) DESC NULLS LAST
Source Dialect	√	√	√	√	√
SELECT "t1"."account_id" FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" WHERE TO_CHAR( CAST( "t2"."date" AS TIMESTAMP ) , 'YYYY' ) = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC NULLS LAST	SELECT "t1"."account_id" FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" WHERE TO_CHAR(CAST("t2"."date" AS TIMESTAMP), 'YYYY') = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC NULLS LAST	select "t1"."account_id" from "loan" "t1" join "account" "t2" on "t1"."account_id" = "t2"."account_id" where ( to_char(cast("t2"."date" as timestamp), 'YYYY') = '1993' and "t1"."duration" > 12 ) order by "t1"."amount" desc nulls last	SELECT "t1"."account_id" FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" WHERE TO_CHAR( CAST( "t2"."date" AS TIMESTAMP ) , 'YYYY' ) = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC NULLS LAST ;	SELECT "t1"."account_id" FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" WHERE TO_CHAR( CAST( "t2"."date" AS TIMESTAMP ) , 'YYYY' ) = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC NULLS LAST	SELECT "t1"."account_id" FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" WHERE TO_CHAR("t2"."date", 'YYYY') = '1993' AND "t1"."duration" > 12 ORDER BY "t1"."amount" DESC NULLS LAST
Source Dialect	√	√	√	√	√
SELECT "t1"."a2" FROM "district" AS "t1" INNER JOIN "client" AS "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t2"."birth_date" = '1976-01-29' AND "t2"."gender" = 'F'	SELECT "t1"."a2" FROM "district" "t1" INNER JOIN "client" "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t2"."birth_date" = '1976-01-29' AND "t2"."gender" = 'F'	select "t1"."a2" from "district" "t1" join "client" "t2" on "t1"."district_id" = "t2"."district_id" where ( "t2"."birth_date" = '1976-01-29' and "t2"."gender" = 'F' )	SELECT "t1"."a2" FROM "district" "t1" INNER JOIN "client" "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t2"."birth_date" = '1976-01-29' AND "t2"."gender" = 'F'	Answer not returned in the given format!	SELECT "t1"."a2" FROM "district" "t1" INNER JOIN "client" "t2" ON "t1"."district_id" = "t2"."district_id" WHERE "t2"."birth_date" = TO_DATE('1976-01-29', 'YYYY-MM-DD') AND "t2"."gender" = 'F'
Source Dialect	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-00900: invalid SQL statement Help: https://docs.oracle.com/error-help/db/ora-00900/	√
SELECT CAST( ( SUM( CASE WHEN "t3"."date" = '1998-12-27' THEN "t3"."balance" ELSE 0 END ) - SUM( CASE WHEN "t3"."date" = '1993-03-22' THEN "t3"."balance" ELSE 0 END ) ) AS REAL ) * 100 / NULLIF( SUM( CASE WHEN "t3"."date" = '1993-03-22' THEN "t3"."balance" ELSE 0 END ) , 0 ) FROM "loan" AS "t1" INNER JOIN "account" AS "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "trans" AS "t3" ON "t3"."account_id" = "t2"."account_id" WHERE "t1"."date" = '1993-07-05'	SELECT CAST((SUM(CASE WHEN "t3"."date" = '1998-12-27' THEN "t3"."balance" ELSE 0 END) - SUM(CASE WHEN "t3"."date" = '1993-03-22' THEN "t3"."balance" ELSE 0 END)) AS FLOAT) * 100 / NULLIF(SUM(CASE WHEN "t3"."date" = '1993-03-22' THEN "t3"."balance" ELSE 0 END), 0) FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "trans" "t3" ON "t3"."account_id" = "t2"."account_id" WHERE "t1"."date" = '1993-07-05'	select ((cast((sum( case when "t3"."date" = '1998-12-27' then "t3"."balance" else 0 end ) - sum( case when "t3"."date" = '1993-03-22' then "t3"."balance" else 0 end )) as real) * 100) / nullif( sum( case when "t3"."date" = '1993-03-22' then "t3"."balance" else 0 end ), 0 )) from "loan" "t1" join "account" "t2" on "t1"."account_id" = "t2"."account_id" join "trans" "t3" on "t3"."account_id" = "t2"."account_id" where "t1"."date" = '1993-07-05'	SELECT CAST( ( SUM( CASE WHEN "t3"."date" = '1998-12-27' THEN "t3"."balance" ELSE 0 END ) - SUM( CASE WHEN "t3"."date" = '1993-03-22' THEN "t3"."balance" ELSE 0 END ) ) AS BINARY_FLOAT ) * 100 / NULLIF( SUM( CASE WHEN "t3"."date" = '1993-03-22' THEN "t3"."balance" ELSE 0 END ) , 0 ) FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "trans" "t3" ON "t3"."account_id" = "t2"."account_id" WHERE "t1"."date" = '1993-07-05'	Answer not returned in the given format!	SELECT CAST( ( SUM( CASE WHEN "t3"."date" = TO_DATE('1998-12-27', 'YYYY-MM-DD') THEN "t3"."balance" ELSE 0 END ) - SUM( CASE WHEN "t3"."date" = TO_DATE('1993-03-22', 'YYYY-MM-DD') THEN "t3"."balance" ELSE 0 END ) ) AS FLOAT ) * 100 / NULLIF( SUM( CASE WHEN "t3"."date" = TO_DATE('1993-03-22', 'YYYY-MM-DD') THEN "t3"."balance" ELSE 0 END ), 0 ) FROM "loan" "t1" INNER JOIN "account" "t2" ON "t1"."account_id" = "t2"."account_id" INNER JOIN "trans" "t3" ON "t3"."account_id" = "t2"."account_id" WHERE "t1"."date" = TO_DATE('1993-07-05', 'YYYY-MM-DD')
Source Dialect	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-00900: invalid SQL statement Help: https://docs.oracle.com/error-help/db/ora-00900/	√
SELECT DISTINCT "t1"."id" , EXTRACT( YEAR FROM CURRENT_TIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) AS "age" FROM "patient" AS "t1" INNER JOIN "examination" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."rvvt" = '+'	SELECT DISTINCT "t1"."id", EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM "t1"."birthday") AS "age" FROM "patient" "t1" INNER JOIN "examination" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."rvvt" = '+'	select distinct "t1"."id", (extract(year from current_timestamp) - extract(year from "t1"."birthday")) "age" from "patient" "t1" join "examination" "t2" on "t1"."id" = "t2"."id" where "t2"."rvvt" = '+'	SELECT DISTINCT "t1"."id" , EXTRACT( YEAR FROM SYSTIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age" FROM "patient" "t1" INNER JOIN "examination" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."rvvt" = '+' ;	SELECT DISTINCT "t1"."id" , EXTRACT( YEAR FROM CURRENT_TIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age" FROM "patient" "t1" INNER JOIN "examination" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."rvvt" = '+'	SELECT DISTINCT "t1"."id", EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM "t1"."birthday") AS "age" FROM "patient" "t1" INNER JOIN "examination" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."rvvt" = '+'
Source Dialect	√	√	√	√	√
SELECT DISTINCT "t1"."id" , "t1"."sex" , EXTRACT( YEAR FROM CURRENT_TIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) AS "age" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."glu" >= 180 AND "t2"."t-cho" < 250	SELECT DISTINCT "t1"."id", "t1"."sex", EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM "t1"."birthday") AS "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."glu" >= 180 AND "t2"."t-cho" < 250	select distinct "t1"."id", "t1"."sex", (extract(year from current_timestamp) - extract(year from "t1"."birthday")) "age" from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where ( "t2"."glu" >= 180 and "t2"."t-cho" < 250 )	SELECT DISTINCT "t1"."id" , "t1"."sex" , EXTRACT( YEAR FROM SYSTIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."glu" >= 180 AND "t2"."t" - "cho" < 250	SELECT DISTINCT "t1"."id" , "t1"."sex" , EXTRACT( YEAR FROM CURRENT_TIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."glu" >= 180 AND "t2"."t-cho" < 250	SELECT DISTINCT "t1"."id", "t1"."sex", EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM "t1"."birthday") AS "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."glu" >= 180 AND "t2"."t-cho" < 250
Source Dialect	√	√	ORA-00904: "cho": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	√	√
SELECT DISTINCT "t1"."id" , EXTRACT( YEAR FROM CURRENT_TIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) AS "age" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" IN ( SELECT "id" FROM "laboratory" WHERE "hct" >= 52 GROUP BY "id" HAVING COUNT( "id" ) >= 2 )	SELECT DISTINCT "t1"."id", EXTRACT(YEAR FROM CURRENT_TIMESTAMP) - EXTRACT(YEAR FROM "t1"."birthday") AS "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" IN (SELECT "id" FROM "laboratory" WHERE "hct" >= 52 GROUP BY "id" HAVING COUNT("id") >= 2)	select distinct "t1"."id", (extract(year from current_timestamp) - extract(year from "t1"."birthday")) "age" from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where "t1"."id" in ( select "id" from "laboratory" where "hct" >= 52 group by "id" having count("id") >= 2 )	SELECT DISTINCT "t1"."id" , EXTRACT( YEAR FROM SYSTIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" IN ( SELECT "id" FROM "laboratory" WHERE "hct" >= 52 GROUP BY "id" HAVING COUNT( "id" ) >= 2 ) ;	SELECT DISTINCT "t1"."id" , EXTRACT( YEAR FROM CURRENT_TIMESTAMP ) - EXTRACT( YEAR FROM "t1"."birthday" ) "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" IN ( SELECT "id" FROM "laboratory" WHERE "hct" >= 52 GROUP BY "id" HAVING COUNT( "id" ) >= 2 )	SELECT DISTINCT "t1"."id", EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM "t1"."birthday") AS "age" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t1"."id" IN ( SELECT "id" FROM "laboratory" WHERE "hct" >= 52 GROUP BY "id" HAVING COUNT("id") >= 2 )
Source Dialect	√	√	√	√	√
SELECT DISTINCT "t1"."id" FROM "patient" AS "t1" INNER JOIN "laboratory" AS "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND EXTRACT( YEAR FROM "t2"."date" ) - EXTRACT( YEAR FROM "t1"."birthday" ) < 50 AND EXTRACT( YEAR FROM "t2"."date" ) = 1984	SELECT DISTINCT "t1"."id" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND EXTRACT(YEAR FROM "t2"."date") - EXTRACT(YEAR FROM "t1"."birthday") < 50 AND EXTRACT(YEAR FROM "t2"."date") = 1984	select distinct "t1"."id" from "patient" "t1" join "laboratory" "t2" on "t1"."id" = "t2"."id" where ( "t2"."plt" between 100 and 400 and (extract(year from "t2"."date") - extract(year from "t1"."birthday")) < 50 and extract(year from "t2"."date") = 1984 )	SELECT DISTINCT "t1"."id" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND EXTRACT( YEAR FROM "t2"."date" ) - EXTRACT( YEAR FROM "t1"."birthday" ) < 50 AND EXTRACT( YEAR FROM "t2"."date" ) = 1984 ;	SELECT DISTINCT "t1"."id" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND EXTRACT( YEAR FROM "t2"."date" ) - EXTRACT( YEAR FROM "t1"."birthday" ) < 50 AND EXTRACT( YEAR FROM "t2"."date" ) = 1984	SELECT DISTINCT "t1"."id" FROM "patient" "t1" INNER JOIN "laboratory" "t2" ON "t1"."id" = "t2"."id" WHERE "t2"."plt" BETWEEN 100 AND 400 AND EXTRACT( YEAR FROM "t2"."date" ) - EXTRACT( YEAR FROM "t1"."birthday" ) < 50 AND EXTRACT( YEAR FROM "t2"."date" ) = 1984
Source Dialect	√	√	√	√	√
SELECT "t1"."name" FROM "league" AS "t1" INNER JOIN "match" AS "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING ( CAST( SUM( "t2"."home_team_goal" ) AS REAL ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) - ( CAST( SUM( "t2"."away_team_goal" ) AS REAL ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) > 0	SELECT "t1"."name" FROM "league" "t1" INNER JOIN "match" "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING (CAST(SUM("t2"."home_team_goal") AS FLOAT) / NULLIF(COUNT(DISTINCT "t2"."id"), 0)) - (CAST(SUM("t2"."away_team_goal") AS FLOAT) / NULLIF(COUNT(DISTINCT "t2"."id"), 0)) > 0	select "t1"."name" from "league" "t1" join "match" "t2" on "t1"."id" = "t2"."league_id" where "t2"."season" = '2009/2010' group by "t1"."name" having ((cast(sum("t2"."home_team_goal") as real) / nullif( count(distinct "t2"."id"), 0 )) - (cast(sum("t2"."away_team_goal") as real) / nullif( count(distinct "t2"."id"), 0 ))) > 0	SELECT "t1"."name" FROM "league" "t1" INNER JOIN "match" "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING ( CAST( SUM( "t2"."home_team_goal" ) AS BINARY_FLOAT ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) - ( CAST( SUM( "t2"."away_team_goal" ) AS BINARY_FLOAT ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) > 0 ;	SELECT "t1"."name" FROM "league" "t1" INNER JOIN "match" "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING ( CAST( SUM( "t2"."home_team_goal" ) AS REAL ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) - ( CAST( SUM( "t2"."away_team_goal" ) AS REAL ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) > 0	SELECT "t1"."name" FROM "league" "t1" INNER JOIN "match" "t2" ON "t1"."id" = "t2"."league_id" WHERE "t2"."season" = '2009/2010' GROUP BY "t1"."name" HAVING ( CAST( SUM( "t2"."home_team_goal" ) AS NUMBER ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) - ( CAST( SUM( "t2"."away_team_goal" ) AS NUMBER ) / NULLIF( COUNT( DISTINCT "t2"."id" ) , 0 ) ) > 0
Source Dialect	√	√	√	√	√
SELECT CAST( SUM( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END ) AS REAL ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END ) , 0 ) - CAST( SUM( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END ) AS REAL ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END ) , 0 ) FROM "player" AS "t1" INNER JOIN "player_attributes" AS "t2" ON "t1"."player_api_id" = "t2"."player_api_id"	SELECT CAST(SUM(CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END) AS FLOAT) / NULLIF(COUNT(CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END), 0) - CAST(SUM(CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END) AS FLOAT) / NULLIF(COUNT(CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END), 0) FROM "player" "t1" INNER JOIN "player_attributes" "t2" ON "t1"."player_api_id" = "t2"."player_api_id"	select ((cast(sum( case when "t1"."player_name" = 'Abdou Diallo' then "t2"."ball_control" else 0 end ) as real) / nullif( count( case when "t1"."player_name" = 'Abdou Diallo' then "t2"."id" else null end ), 0 )) - (cast(sum( case when "t1"."player_name" = 'Aaron Appindangoye' then "t2"."ball_control" else 0 end ) as real) / nullif( count( case when "t1"."player_name" = 'Aaron Appindangoye' then "t2"."id" else null end ), 0 ))) from "player" "t1" join "player_attributes" "t2" on "t1"."player_api_id" = "t2"."player_api_id"	SELECT CAST( SUM( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END ) AS BINARY_FLOAT ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END ) , 0 ) - CAST( SUM( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END ) AS BINARY_FLOAT ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END ) , 0 ) FROM "player" "t1" INNER JOIN "player_attributes" "t2" ON "t1"."player_api_id" = "t2"."player_api_id" ;	SELECT CAST( SUM( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END ) AS REAL ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END ) , 0 ) - CAST( SUM( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END ) AS REAL ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END ) , 0 ) FROM "player" "t1" INNER JOIN "player_attributes" "t2" ON "t1"."player_api_id" = "t2"."player_api_id"	SELECT CAST( SUM( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."ball_control" ELSE 0 END ) AS FLOAT ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Abdou Diallo' THEN "t2"."id" ELSE NULL END ), 0 ) - CAST( SUM( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."ball_control" ELSE 0 END ) AS FLOAT ) / NULLIF( COUNT( CASE WHEN "t1"."player_name" = 'Aaron Appindangoye' THEN "t2"."id" ELSE NULL END ), 0 ) FROM "player" "t1" INNER JOIN "player_attributes" "t2" ON "t1"."player_api_id" = "t2"."player_api_id"
Source Dialect	√	√	Inconsistent Result	√	√
SELECT "t1"."name" FROM "races" AS "t1" INNER JOIN "driverstandings" AS "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" AS "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Alex' AND "t3"."surname" = 'Yoong' AND "t2"."position" < 20	SELECT "t1"."name" FROM "races" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Alex' AND "t3"."surname" = 'Yoong' AND "t2"."position" < 20	select "t1"."name" from "races" "t1" join "driverstandings" "t2" on "t2"."raceid" = "t1"."raceid" join "drivers" "t3" on "t3"."driverid" = "t2"."driverid" where ( "t3"."forename" = 'Alex' and "t3"."surname" = 'Yoong' and "t2"."position" < 20 )	SELECT "t1"."name" FROM "races" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Alex' AND "t3"."surname" = 'Yoong' AND "t2"."position" < 20 ;	SELECT "t1"."name" FROM "races" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Alex' AND "t3"."surname" = 'Yoong' AND "t2"."position" < 20	SELECT "t1"."name" FROM "races" "t1" INNER JOIN "driverstandings" "t2" ON "t2"."raceid" = "t1"."raceid" INNER JOIN "drivers" "t3" ON "t3"."driverid" = "t2"."driverid" WHERE "t3"."forename" = 'Alex' AND "t3"."surname" = 'Yoong' AND "t2"."position" < 20
Source Dialect	√	√	√	√	√
SELECT "t1"."fastestlap" FROM "results" AS "t1" INNER JOIN "races" AS "t2" ON "t1"."raceid" = "t2"."raceid" WHERE "t2"."year" = 2009 AND "t1"."time" LIKE ':%:.'	SELECT "t1"."fastestlap" FROM "results" "t1" INNER JOIN "races" "t2" ON "t1"."raceid" = "t2"."raceid" WHERE "t2"."year" = 2009 AND "t1"."time" LIKE ':%:.'	select "t1"."fastestlap" from "results" "t1" join "races" "t2" on "t1"."raceid" = "t2"."raceid" where ( "t2"."year" = 2009 and "t1"."time" like ':%:.' )	SELECT "t1"."fastestlap" FROM "results" "t1" INNER JOIN "races" "t2" ON "t1"."raceid" = "t2"."raceid" WHERE "t2"."year" = 2009 AND "t1"."time" LIKE ':%:.' ;	SELECT "t1"."fastestlap" FROM "results" "t1" INNER JOIN "races" "t2" ON "t1"."raceid" = "t2"."raceid" WHERE "t2"."year" = 2009 AND "t1"."time" LIKE ':%:.'	SELECT "t1"."fastestlap" FROM "results" "t1" INNER JOIN "races" "t2" ON "t1"."raceid" = "t2"."raceid" WHERE "t2"."year" = 2009 AND "t1"."time" LIKE ':%:.__'
Source Dialect	√	√	√	√	√
SELECT "superhero_name" FROM "superhero" AS "t1" WHERE EXISTS ( SELECT 1 FROM "hero_attribute" AS "t2" INNER JOIN "attribute" AS "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Durability' AND "t2"."attribute_value" < 50 AND "t1"."id" = "t2"."hero_id" )	SELECT "superhero_name" FROM "superhero" "t1" WHERE EXISTS(SELECT 1 FROM "hero_attribute" "t2" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Durability' AND "t2"."attribute_value" < 50 AND "t1"."id" = "t2"."hero_id")	select "superhero_name" from "superhero" "t1" where exists ( select 1 from "hero_attribute" "t2" join "attribute" "t3" on "t2"."attribute_id" = "t3"."id" where ( "t3"."attribute_name" = 'Durability' and "t2"."attribute_value" < 50 and "t1"."id" = "t2"."hero_id" ) )	SELECT "superhero_name" FROM "superhero" "t1" WHERE EXISTS ( SELECT 1 FROM "hero_attribute" "t2" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Durability' AND "t2"."attribute_value" < 50 AND "t1"."id" = "t2"."hero_id" ) ;	SELECT "superhero_name" FROM "superhero" "t1" WHERE EXISTS ( SELECT 1 FROM "hero_attribute" "t2" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Durability' AND "t2"."attribute_value" < 50 AND "t1"."id" = "t2"."hero_id" )	SELECT "superhero_name" FROM "superhero" "t1" WHERE EXISTS ( SELECT 1 FROM "hero_attribute" "t2" INNER JOIN "attribute" "t3" ON "t2"."attribute_id" = "t3"."id" WHERE "t3"."attribute_name" = 'Durability' AND "t2"."attribute_value" < 50 AND "t1"."id" = "t2"."hero_id" )
Source Dialect	√	√	√	√	√
SELECT COUNT( "id" ) FROM "users" WHERE DATE( "lastaccessdate" ) > '2014-09-01'	SELECT COUNT("id") FROM "users" WHERE DATE("lastaccessdate") > '2014-09-01'	select count("id") from "users" where cast("lastaccessdate" as date) > '2014-09-01'	SELECT COUNT( "id" ) FROM "users" WHERE TO_DATE( lastaccessdate ) > '2014-09-01'	SELECT COUNT( "id" ) FROM "users" WHERE "lastaccessdate" > TO_DATE('2014-09-01', 'YYYY-MM-DD')	SELECT COUNT( "id" ) FROM "users" WHERE TRUNC( "lastaccessdate" ) > TO_DATE('2014-09-01', 'YYYY-MM-DD')
Source Dialect	ORA-00936: missing expression Help: https://docs.oracle.com/error-help/db/ora-00936/	ORA-01861: literal does not match format string Help: https://docs.oracle.com/error-help/db/ora-01861/	ORA-00904: "LASTACCESSDATE": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/	Inconsistent Result	√

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

FilesExpand file tree

RESULT.md

Latest commit

History

RESULT.md

File metadata and controls