create SQL for update table
Budget: $10 – $30 USD
attached is a table with the following fields
reading date - which has the day and time of a water meter event
mone - the number of the water meter
water_count the water meter reading
qty - the difference between the former reading (if there was) and the current reading)
i need 2 SQL :
1) update qty with right quantities
2) show total hourly consumption of this meter
reading date - which has the day and time of a water meter event
mone - the number of the water meter
water_count the water meter reading
qty - the difference between the former reading (if there was) and the current reading)
i need 2 SQL :
1) update qty with right quantities
2) show total hourly consumption of this meter