Domain (DB)
California Schools
Question
How many schools with an average score in Math greater than 400 in the SAT test are exclusively virtual?
Answer
4.000
Schema: Omitted for brevity (available at bird-bench.github.io)
External Info: Exclusively virtual refers to Virtual = 'F'
Answer SQL: SELECT COUNT(DISTINCT T2.School) FROM satscores AS T1 INNER JOIN schools AS T2 ON T1.cds = T2.CDSCode WHERE T2.Virtual = 'F' AND T1.AvgScrMath > 400
Every California school that is exclusively virtual and has an average SAT Math score greater than 400 provides each enrolled student with a school-issued laptop.
Label:
NOT ENOUGH INFO(OUT-OF-SCHEMA)