# bird-bench / superhero__831 - taskset: [bird-bench](https://harnessreport.com/tasks/bird-bench.md) - difficulty: easy - category: database - language: - runnable from the site: no - agent timeout: 3600s ## Results by harness _none yet_ ## Instruction ``` You are given a natural language question and a SQLite database. Your task is to write a SQL query that answers the question. Database file: `/app/db.sqlite` You may use `sqlite3` or Python to inspect the schema and data. Do not modify the database. Question: What is Abomination's eye colour? Evidence: Abomination refers to superhero_name = 'Abomination'; eye colour refers to colour.colour where eye_colour_id = colour.id; Schema: CREATE TABLE alignment ( id INTEGER not null primary key, alignment TEXT default NULL ) CREATE TABLE attribute ( id INTEGER not null primary key, attribute_name TEXT default NULL ) CREATE TABLE colour ( id INTEGER not null primary key, colour TEXT default NULL ) CREATE TABLE gender ( id INTEGER not null primary key, gender TEXT default NULL ) CREATE TABLE hero_attribute ( hero_id INTEGER default NULL, attribute_id INTEGER default NULL, attribute_value INTEGER default NULL, foreign key (attribute_id) references attribute(id), foreign key (hero_id) references superhero(id) ) CREATE TABLE hero_power ( hero_id INTEGER default NULL, power_id INTEGER default NULL, foreign key (hero_id) references superhero(id), foreign key (power_id) references superpower(id) ) CREATE TABLE publisher ( id INTEGER not null primary key, publisher_name TEXT default NULL ) CREATE TABLE race ( id INTEGER not null primary key, race TEXT default NULL ) CREATE TABLE superhero ( id INTEGER not null primary key, superhero_name TEXT default NULL, full_name TEXT default NULL, gender_id INTEGER default NULL, eye_colour_id INTEGER default NULL, hair_colour_id INTEGER default NULL, skin_colour_id INTEGER default NULL, race_id INTEGER default NULL, publisher_id INTEGER default NULL, alignment_id INTEGER default NULL, height_cm INTEGER default NULL, weight_kg INTEGER default NULL, foreign key (alignment_id) references alignment(id), foreign key (eye_colour_id) references colour(id), foreign key (gender_id) references gender(id), foreign key (hair_colour_id) references colour(id), foreign key (publisher_id) references publisher(id), foreign key (race_id) references race(id), foreign key (skin_colour_id) references colour(id) ) CREATE TABLE superpower ( id INTEGER not null primary key, power_name TEXT default NULL ) Output: Write ONLY the SQL query to `/app/answer.sql`. Do not include code fences, comments, or explanations. ``` --- Harness Report runs agent harnesses from their GitHub repos on Harbor tasks and records every model call. Every page is also `.md` and `.json`; index: https://harnessreport.com/llms.txt · MCP: https://harnessreport.com/mcp