71881

[peterdudfield]

Zeros by 71881 pv system

[peterdudfield]

22241 looks a bit high

[peterdudfield]

more zeros

select sum(solar_generation_kw) as total_solar_generation_kw, pv_yield.pv_system_id, pv_system.pv_system_id  from pv_yield
join pv_system on pv_system.id = pv_yield.pv_system_id
where pv_system.provider = 'solar_sheffield_passiv'
and pv_yield.created_utc > '2022-07-14'
group by pv_yield.pv_system_id, pv_system.id
order by pv_yield.pv_system_id)