About
Terms
SQL
About
Terms
SQL
SELECT grade_level, (SUM(merged_proficient_or_above_count) * 100.0) / CAST(SUM(student_subgroup_total_tested) AS NUMERIC) AS proficiency_rate FROM stats_v11 WHERE stats_v11.data_level = 'STATE' AND stats_v11.student_group = 'ALL_STUDENTS' AND grade_level = 'GRADE_8' AND subject = 'ELA' AND school_year = '2022-23' AND merged_proficient_or_above_count IS NOT NULL AND student_subgroup_total_tested IS NOT NULL AND student_subgroup_total_tested > 0 GROUP BY grade_level
Notable Events
Math vs Reading Performance in Virginia by Grade Level (2012)
"Math vs reading in Virginia for 2012 by grade level"
Reading vs Science Performance in Georgia (2014)
"Reading vs science in Georgia for 2014"
ELA vs Social Studies Performance in Georgia for 2019 by English Proficiency Status
"ELA vs social studies in Georgia for 2019 by english proficiency status"
Achievement Gap in Writing Over Time between English Proficient and English Learning Students in Virginia
"Achievement gap in Virginia in writing over time between english proficient and english learning students"
Math vs Social Studies Performance in Texas for 2016 by English Proficiency Status
"Math vs social studies in Texas for 2016 by english proficiency status"