# bird-bench / toxicology__229 - 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 molecule TR000, what are the bond types ranked by frequency, how many times does each bond type occur, and how many unique element pairs are connected by each bond type? Also indicate whether each bond type appears multiple times or just once, and show the molecule's label. Evidence: TR000 is the molecule id; bond frequency refers to whether bond_count is greater than 1 Schema: CREATE TABLE `atom` ( `atom_id` TEXT NOT NULL, `molecule_id` TEXT DEFAULT NULL, `element` TEXT DEFAULT NULL, PRIMARY KEY (`atom_id`), FOREIGN KEY (`molecule_id`) REFERENCES `molecule` (`molecule_id`) ) CREATE TABLE `bond` ( `bond_id` TEXT NOT NULL, `molecule_id` TEXT DEFAULT NULL, `bond_type` TEXT DEFAULT NULL, PRIMARY KEY (`bond_id`), FOREIGN KEY (`molecule_id`) REFERENCES `molecule` (`molecule_id`) ) CREATE TABLE `connected` ( `atom_id` TEXT NOT NULL, `atom_id2` TEXT NOT NULL, `bond_id` TEXT DEFAULT NULL, PRIMARY KEY (`atom_id`,`atom_id2`), FOREIGN KEY (`atom_id`) REFERENCES `atom` (`atom_id`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`atom_id2`) REFERENCES `atom` (`atom_id`) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (`bond_id`) REFERENCES `bond` (`bond_id`) ON DELETE CASCADE ON UPDATE CASCADE ) CREATE TABLE `molecule` ( `molecule_id` TEXT NOT NULL, `label` TEXT DEFAULT NULL, PRIMARY KEY (`molecule_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