School Traff Bad

with in_data as (select 6 as month, 2015 as year)
select s.rtcom_id, s.etap, s.region, s.name, s.finance, period,
sum(case when m = (select month from in_data) then rs.local_traf else 0 end) / 2 ^ 20,
sum(case when m = (select month from in_data) then rs.notlocal_traf else 0 end)  / 2 ^ 20,
sum(case when m = (select month from in_data) then rs.notlocal_traf + rs.local_traf else 0 end) / 2 ^ 20,
sum(case when m <=(select month from in_data) then rs.local_traf+rs.notlocal_traf else 0 end)  / 2 ^ 20, ip
from (select '8-14' as period, y as y, m as m, ip_num_to_str(ip)::inet as ip,
sum(case when is_local = true then bytes else 0 end) as local_traf,
sum(case when is_local = false then bytes else 0 end) as notlocal_traf
from nf_statistic n
where h between 8 and 14
group by ip, y, m
union select '14-8', y, m, ip_num_to_str(ip)::inet,
sum(case when is_local = true then bytes else 0 end),
sum(case when is_local = false then bytes else 0 end)
from nf_statistic n
where not h between 8 and 14
group by ip, y, m) as rs
inner join schools s on s.inetsubnet = rs.ip
where y = (select year from in_data) and s.deleted = false
group by ip, y, period, s.rtcom_id, s.name, s.region, s.etap, s.finance
order by s.name asc, period desc;