schools: grades_by_year_for_state

Custom SQL query (hide)

select
  grade,
  sum(total_int) filter (where year = 2015) as total_2015,
  sum(total_int) filter (where year = 2016) as total_2016,
  sum(total_int) filter (where year = 2017) as total_2017,
  sum(total_int) filter (where year = 2018) as total_2018,
  sum(total_int) filter (where year = 2019) as total_2019,
  sum(total_int) filter (where year = 2020) as total_2020,
  sum(total_int) filter (where year = 2021) as total_2021,
  round((1.0 * (sum(total_int) filter (where year = 2021)) - (sum(total_int) filter (where year = 2020))) / (sum(total_int) filter (where year = 2020)) * 100.0, 2) as percent_change_2020_2021
from enrollments
where state = :state
and term = :term
group by grade
order by percent_change_2020_2021

Query parameters

state

term

Edit SQL