# bird-bench / student_club__1387 - 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 student has been entrusted to manage the budget for the Yearly Kickoff? Evidence: name of students means the full name; full name refers to first_name, last_name;'Yearly Kickoff' is an event name; Schema: CREATE TABLE "attendance" ( link_to_event TEXT, link_to_member TEXT, primary key (link_to_event, link_to_member), foreign key (link_to_event) references event(event_id), foreign key (link_to_member) references member(member_id) ) CREATE TABLE "budget" ( budget_id TEXT primary key, category TEXT, spent REAL, remaining REAL, amount INTEGER, event_status TEXT, link_to_event TEXT, foreign key (link_to_event) references event(event_id) ) CREATE TABLE event ( event_id TEXT constraint event_pk primary key, event_name TEXT, event_date TEXT, type TEXT, notes TEXT, location TEXT, status TEXT ) CREATE TABLE "expense" ( expense_id TEXT primary key, expense_description TEXT, expense_date TEXT, cost REAL, approved TEXT, link_to_member TEXT, link_to_budget TEXT, foreign key (link_to_budget) references budget(budget_id), foreign key (link_to_member) references member(member_id) ) CREATE TABLE "income" ( income_id TEXT constraint income_pk primary key, date_received TEXT, amount INTEGER, source TEXT, notes TEXT, link_to_member TEXT, foreign key (link_to_member) references member(member_id) ) CREATE TABLE major ( major_id TEXT constraint major_pk primary key, major_name TEXT, department TEXT, college TEXT ) CREATE TABLE "member" ( member_id TEXT constraint member_pk primary key, first_name TEXT, last_name TEXT, email TEXT, position TEXT, t_shirt_size TEXT, phone TEXT, zip INTEGER, link_to_major TEXT, foreign key (link_to_major) references major(major_id), foreign key (zip) references zip_code(zip_code) ) CREATE TABLE zip_code ( zip_code INTEGER constraint zip_code_pk primary key, type TEXT, city TEXT, county TEXT, state TEXT, short_state TEXT ) 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