Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am gpeng on github.
  • I am gpeng (https://keybase.io/gpeng) on keybase.
  • I have a public key ASB_s078QkolN2cwe1JPkgMC0a8onPvfG_cJyiEKcUeVPwo

To claim this, I am signing this object:

select new_contract.contract_end_date, new_contract.combined_meter_number, previous_contract.new_supplier_estimated_start_date
from contract as new_contract
left outer join
(select new_supplier_contract_estimated_start_date from contract) as previous_contract on
previous_contract.combined_meter_number = new_contract.combined_meter_number