# bird-bench / debit_card_specializing__1526 - taskset: [bird-bench](https://harnessreport.com/tasks/bird-bench.md) - difficulty: hard - 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: For the customer who paid 634.8 in 2012/8/25, what was the consumption decrease rate from Year 2012 to 2013? Evidence: '2012/8/24' can be represented by '2012-08-24'; Consumption decrease rate = (consumption_2012 - consumption_2013) / consumption_2012 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