agg_load_min_by_h_hh_p_sumavg.sql

with 
base_data as
(
select 
	alm.*
	, dd.day
	, dd.hour
	, dd.minute
	, dd.hourminute
  from 
        agg_load_min_by_h_hh_p alm
     inner join
        dim_date dd
        on 
        alm.ts = dd.ts
)
select 
 row_number() over() as id
, min(bd.ts) as ts
, sum(bd.value) as value  --sum of avg(...)
, max(bd.property) as property
, bd.house_id  
, bd.household_id
, bd.plug_id
from base_data bd
group by 
  bd.house_id
 ,bd.household_id
 ,bd.plug_id 
 ,bd.day
 ,bd.hour
 ,bd.hourminute