create sql QUery
Budget: $10 – $30 USD
attached is a table in MySQL
in the table, there are 3 important fields
reading_date ,mone, water_count
there are several values for each day ib various hours
mission: create an efficient SQL that will print out
reading_date, mone, water_count :
with the following rules
a) start from a given date
b) print only 1 record with the last water_count of that day!
again only 1 per day with the last hour!
in the table, there are 3 important fields
reading_date ,mone, water_count
there are several values for each day ib various hours
mission: create an efficient SQL that will print out
reading_date, mone, water_count :
with the following rules
a) start from a given date
b) print only 1 record with the last water_count of that day!
again only 1 per day with the last hour!