# bird-bench / thrombosis_prediction__1301 - taskset: [bird-bench](https://harnessreport.com/tasks/bird-bench.md) - difficulty: easy - 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: Please list the IDs of the patients with no thrombosis and an abnormal level of creatinine phosphokinase. Evidence: no thrombosis refers to Thrombosis = 0 ; abnormal level of creatinine phosphokinase refers to CPK < 250; Schema: CREATE TABLE Examination ( ID INTEGER null, `Examination Date` DATE null, `aCL IgG` REAL null, `aCL IgM` REAL null, ANA INTEGER null, `ANA Pattern` TEXT null, `aCL IgA` INTEGER null, Diagnosis TEXT null, KCT TEXT null, RVVT TEXT null, LAC TEXT null, Symptoms TEXT null, Thrombosis INTEGER null, foreign key (ID) references Patient (ID) on update cascade on delete cascade ) CREATE TABLE Laboratory ( ID INTEGER default 0 not null, Date DATE default '0000-00-00' not null, GOT INTEGER null, GPT INTEGER null, LDH INTEGER null, ALP INTEGER null, TP REAL null, ALB REAL null, UA REAL null, UN INTEGER null, CRE REAL null, `T-BIL` REAL null, `T-CHO` INTEGER null, TG INTEGER null, CPK INTEGER null, GLU INTEGER null, WBC REAL null, RBC REAL null, HGB REAL null, HCT REAL null, PLT INTEGER null, PT REAL null, APTT INTEGER null, FG REAL null, PIC INTEGER null, TAT INTEGER null, TAT2 INTEGER null, `U-PRO` TEXT null, IGG INTEGER null, IGA INTEGER null, IGM INTEGER null, CRP TEXT null, RA TEXT null, RF TEXT null, C3 INTEGER null, C4 INTEGER null, RNP TEXT null, SM TEXT null, SC170 TEXT null, SSA TEXT null, SSB TEXT null, CENTROMEA TEXT null, DNA TEXT null, `DNA-II` INTEGER null, primary key (ID, Date), foreign key (ID) references Patient (ID) on update cascade on delete cascade ) CREATE TABLE Patient ( ID INTEGER default 0 not null primary key, SEX TEXT null, Birthday DATE null, Description DATE null, `First Date` DATE null, Admission TEXT null, Diagnosis TEXT null ) 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