# bird-bench / california_schools__32 - 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 the top 5 schools with the highest number of students eligible for free or reduced price meals in grades K-12 among schools with ownership code 66, what are their eligibility rates, SAT performance metrics, and how do they compare in terms of SAT participation and high scorer rates? Evidence: Eligible free or reduced price meal rate for K-12 = FRPM Count (K-12) / Enrollment (K-12); ownership code 66 refers to SOC = '66'; high scorer rate refers to students scoring 1500 or above on SAT Schema: CREATE TABLE frpm ( CDSCode TEXT not null primary key, `Academic Year` TEXT null, `County Code` TEXT null, `District Code` INTEGER null, `School Code` TEXT null, `County Name` TEXT null, `District Name` TEXT null, `School Name` TEXT null, `District Type` TEXT null, `School Type` TEXT null, `Educational Option Type` TEXT null, `NSLP Provision Status` TEXT null, `Charter School (Y/N)` INTEGER null, `Charter School Number` TEXT null, `Charter Funding Type` TEXT null, IRC INTEGER null, `Low Grade` TEXT null, `High Grade` TEXT null, `Enrollment (K-12)` REAL null, `Free Meal Count (K-12)` REAL null, `Percent (%) Eligible Free (K-12)` REAL null, `FRPM Count (K-12)` REAL null, `Percent (%) Eligible FRPM (K-12)` REAL null, `Enrollment (Ages 5-17)` REAL null, `Free Meal Count (Ages 5-17)` REAL null, `Percent (%) Eligible Free (Ages 5-17)` REAL null, `FRPM Count (Ages 5-17)` REAL null, `Percent (%) Eligible FRPM (Ages 5-17)` REAL null, `2013-14 CALPADS Fall 1 Certification Status` INTEGER null, foreign key (CDSCode) references schools (CDSCode) ) CREATE TABLE satscores ( cds TEXT not null primary key, rtype TEXT not null, sname TEXT null, dname TEXT null, cname TEXT null, enroll12 INTEGER not null, NumTstTakr INTEGER not null, AvgScrRead INTEGER null, AvgScrMath INTEGER null, AvgScrWrite INTEGER null, NumGE1500 INTEGER null, -- PctGE1500 double null, foreign key (cds) references schools (CDSCode) ) CREATE TABLE schools ( CDSCode TEXT not null primary key, NCESDist TEXT null, NCESSchool TEXT null, StatusType TEXT not null, County TEXT not null, District TEXT not null, School TEXT null, Street TEXT null, StreetAbr TEXT null, City TEXT null, Zip TEXT null, State TEXT null, MailStreet TEXT null, MailStrAbr TEXT null, MailCity TEXT null, MailZip TEXT null, MailState TEXT null, Phone TEXT null, Ext TEXT null, Website TEXT null, OpenDate DATE null, ClosedDate DATE null, Charter INTEGER null, CharterNum TEXT null, FundingType TEXT null, DOC TEXT not null, DOCType TEXT not null, SOC TEXT null, SOCType TEXT null, EdOpsCode TEXT null, EdOpsName TEXT null, EILCode TEXT null, EILName TEXT null, GSoffered TEXT null, GSserved TEXT null, Virtual TEXT null, Magnet INTEGER null, Latitude REAL null, Longitude REAL null, AdmFName1 TEXT null, AdmLName1 TEXT null, AdmEmail1 TEXT null, AdmFName2 TEXT null, AdmLName2 TEXT null, AdmEmail2 TEXT null, AdmFName3 TEXT null, AdmLName3 TEXT null, AdmEmail3 TEXT null, LastUpdate DATE not 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