You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{
"question_id": 772,
"db_id": "superhero",
"question": "List the eyes, hair and skin colour of all female superheroes published by Dark Horse Comics.",
"evidence": "eyes refers to eye_colour_id; hair refers to hair_colour_id; skin colour refers to skin_colour_id; female superheroes refers to gender = 'Female'; published by Dark Horse Comics refers to publisher_name = 'Dark Horse Comics';",
"SQL": "SELECT `T1`.`eye_colour_id`, `T1`.`hair_colour_id`, `T1`.`skin_colour_id` FROM `superhero` AS `T1` INNER JOIN `publisher` AS `T2` ON `T2`.`id` = `T1`.`publisher_id` INNER JOIN `gender` AS `T3` ON `T3`.`id` = `T1`.`gender_id` WHERE `T2`.`publisher_name` = 'Dark Horse Comics' AND `T3`.`gender` = 'Female'",
"difficulty": "challenging",
"res": 0
}
the above SQL return
I suggest the result should be like as follow:
The text was updated successfully, but these errors were encountered:
the above SQL return
I suggest the result should be like as follow:
The text was updated successfully, but these errors were encountered: