# bird-bench / california_schools__79 - 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 fully virtual schools in San Diego and Santa Barbara counties, which county has the most virtual schools? Provide comprehensive statistics including the count, breakdown of charter vs regular schools, enrollment figures, average free/reduced meal percentage, average SAT scores, and identify the largest virtual school by enrollment. Evidence: Fully virtual schools refer to schools where Virtual = 'F'. Charter schools are identified by Charter School (Y/N) = 1. FRPM refers to Free or Reduced Price Meal program eligibility. 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