# bird-bench / formula_1__884 - taskset: [bird-bench](https://harnessreport.com/tasks/bird-bench.md) - difficulty: medium - 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: List the names of all races that occurred in the earliest recorded year and month. Evidence: earliest recorded year and month refers to year = year(min(date)) and month = month(min(date)); Schema: CREATE TABLE circuits ( circuitId INTEGER primary key autoincrement, circuitRef TEXT default '' not null, name TEXT default '' not null, location TEXT, country TEXT, lat REAL, lng REAL, alt INTEGER, url TEXT default '' not null unique ) CREATE TABLE constructorResults ( constructorResultsId INTEGER primary key autoincrement, raceId INTEGER default 0 not null, constructorId INTEGER default 0 not null, points REAL, status TEXT, foreign key (raceId) references races(raceId), foreign key (constructorId) references constructors(constructorId) ) CREATE TABLE constructorStandings ( constructorStandingsId INTEGER primary key autoincrement, raceId INTEGER default 0 not null, constructorId INTEGER default 0 not null, points REAL default 0 not null, position INTEGER, positionText TEXT, wins INTEGER default 0 not null, foreign key (raceId) references races(raceId), foreign key (constructorId) references constructors(constructorId) ) CREATE TABLE constructors ( constructorId INTEGER primary key autoincrement, constructorRef TEXT default '' not null, name TEXT default '' not null unique, nationality TEXT, url TEXT default '' not null ) CREATE TABLE driverStandings ( driverStandingsId INTEGER primary key autoincrement, raceId INTEGER default 0 not null, driverId INTEGER default 0 not null, points REAL default 0 not null, position INTEGER, positionText TEXT, wins INTEGER default 0 not null, foreign key (raceId) references races(raceId), foreign key (driverId) references drivers(driverId) ) CREATE TABLE drivers ( driverId INTEGER primary key autoincrement, driverRef TEXT default '' not null, number INTEGER, code TEXT, forename TEXT default '' not null, surname TEXT default '' not null, dob DATE, nationality TEXT, url TEXT default '' not null unique ) CREATE TABLE lapTimes ( raceId INTEGER not null, driverId INTEGER not null, lap INTEGER not null, position INTEGER, time TEXT, milliseconds INTEGER, primary key (raceId, driverId, lap), foreign key (raceId) references races(raceId), foreign key (driverId) references drivers(driverId) ) CREATE TABLE pitStops ( raceId INTEGER not null, driverId INTEGER not null, stop INTEGER not null, lap INTEGER not null, time TEXT not null, duration TEXT, milliseconds INTEGER, primary key (raceId, driverId, stop), foreign key (raceId) references races(raceId), foreign key (driverId) references drivers(driverId) ) CREATE TABLE qualifying ( qualifyId INTEGER primary key autoincrement, raceId INTEGER default 0 not null, driverId INTEGER default 0 not null, constructorId INTEGER default 0 not null, number INTEGER default 0 not null, position INTEGER, q1 TEXT, q2 TEXT, q3 TEXT, foreign key (raceId) references races(raceId), foreign key (driverId) references drivers(driverId), foreign key (constructorId) references constructors(constructorId) ) CREATE TABLE races ( raceId INTEGER primary key autoincrement, year INTEGER default 0 not null, round INTEGER default 0 not null, circuitId INTEGER default 0 not null, name TEXT default '' not null, date DATE default '0000-00-00' not null, time TEXT, url TEXT unique, foreign key (year) references seasons(year), foreign key (circuitId) references circuits(circuitId) ) CREATE TABLE results ( resultId INTEGER primary key autoincrement, raceId INTEGER default 0 not null, driverId INTEGER default 0 not null, constructorId INTEGER default 0 not null, number INTEGER, grid INTEGER default 0 not null, position INTEGER, positionText TEXT default '' not null, positionOrder INTEGER default 0 not null, points REAL default 0 not null, laps INTEGER default 0 not null, time TEXT, milliseconds INTEGER, fastestLap INTEGER, rank INTEGER default 0, fastestLapTime TEXT, fastestLapSpeed TEXT, statusId INTEGER default 0 not null, foreign key (raceId) references races(raceId), foreign key (driverId) references drivers(driverId), foreign key (constructorId) references constructors(constructorId), foreign key (statusId) references status(statusId) ) CREATE TABLE seasons ( year INTEGER default 0 not null primary key, url TEXT default '' not null unique ) CREATE TABLE status ( statusId INTEGER primary key autoincrement, status TEXT default '' not 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