schools

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