The #AsOf #Join, so useful…
https://github.com/michael-simons/pv/blob/main/schema/R__Create_view_accumulated_yearly_energy_costs.sql#L24
"Give me price that is valid the earliest for this month" in the above example.
#FunWithSQL
Some scripts to work with PV measurements and tooling to record measurements. - michael-simons/pv
Michael Simons