# bird-bench / financial__140 - 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: What is the comprehensive financial profile of all accounts in the Pisek district, including the total number of accounts, average transactions per account, total deposits and withdrawals, average maximum balance, total credit cards issued, total loans issued, percentage of active loan amounts, and number of unique account owners? Evidence: Active loans refer to status = 'A'; PRIJEM refers to deposits; VYDAJ refers to withdrawals; account owners refer to disposition type = 'OWNER' Schema: CREATE TABLE account ( account_id INTEGER default 0 not null primary key, district_id INTEGER default 0 not null, frequency TEXT not null, date DATE not null, foreign key (district_id) references district (district_id) ) CREATE TABLE card ( card_id INTEGER default 0 not null primary key, disp_id INTEGER not null, type TEXT not null, issued DATE not null, foreign key (disp_id) references disp (disp_id) ) CREATE TABLE client ( client_id INTEGER not null primary key, gender TEXT not null, birth_date DATE not null, district_id INTEGER not null, foreign key (district_id) references district (district_id) ) CREATE TABLE disp ( disp_id INTEGER not null primary key, client_id INTEGER not null, account_id INTEGER not null, type TEXT not null, foreign key (account_id) references account (account_id), foreign key (client_id) references client (client_id) ) CREATE TABLE district ( district_id INTEGER default 0 not null primary key, A2 TEXT not null, A3 TEXT not null, A4 TEXT not null, A5 TEXT not null, A6 TEXT not null, A7 TEXT not null, A8 INTEGER not null, A9 INTEGER not null, A10 REAL not null, A11 INTEGER not null, A12 REAL null, A13 REAL not null, A14 INTEGER not null, A15 INTEGER null, A16 INTEGER not null ) CREATE TABLE loan ( loan_id INTEGER default 0 not null primary key, account_id INTEGER not null, date DATE not null, amount INTEGER not null, duration INTEGER not null, payments REAL not null, status TEXT not null, foreign key (account_id) references account (account_id) ) CREATE TABLE `order` ( order_id INTEGER default 0 not null primary key, account_id INTEGER not null, bank_to TEXT not null, account_to INTEGER not null, amount REAL not null, k_symbol TEXT not null, foreign key (account_id) references account (account_id) ) CREATE TABLE trans ( trans_id INTEGER default 0 not null primary key, account_id INTEGER default 0 not null, date DATE not null, type TEXT not null, operation TEXT null, amount INTEGER not null, balance INTEGER not null, k_symbol TEXT null, bank TEXT null, account INTEGER null, foreign key (account_id) references account (account_id) ) 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