Calculating the difference in energy readings using difference in dates

Hi All,   I have 3 columns. I wanna find the difference between the last and the first readings of "total_energy_generated_till" based on the timestamp of a day and based on the inverter ID. How do...