# bird-bench / toxicology__207 - 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 each element that participates in double bonds, what is the count of atoms, the number of molecules containing them, their percentage of all atoms in the database, and examples of up to 3 molecules (with labels) where they appear in double bonds? Evidence: Double bonds refer to bond_type = '='. Only consider molecules that contain at least one double bond. 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