# bird-bench / debit_card_specializing__1474 - 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: Which customers, paying in CZK, consumed the most gas in 2011? Evidence: Year 2011 can be presented as Between 201101 And 201112, which means between January and December in 2011 Schema: CREATE TABLE customers ( CustomerID INTEGER UNIQUE not null primary key, Segment TEXT null, Currency TEXT null ) CREATE TABLE gasstations ( GasStationID INTEGER UNIQUE not null primary key, ChainID INTEGER null, Country TEXT null, Segment TEXT null ) CREATE TABLE products ( ProductID INTEGER UNIQUE not null primary key, Description TEXT null ) CREATE TABLE "transactions_1k" ( TransactionID INTEGER primary key autoincrement, Date DATE, Time TEXT, CustomerID INTEGER, CardID INTEGER, GasStationID INTEGER, ProductID INTEGER, Amount INTEGER, Price REAL ) CREATE TABLE "yearmonth" ( CustomerID INTEGER not null references customers on update cascade on delete cascade references customers, Date TEXT not null, Consumption REAL, primary key (Date, CustomerID) ) 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