Query to get the volume used up to the current date from the beginning of the fiscal year.
 SELECT * FROM current_devices cd
        INNER JOIN (SELECT MAX(date_timestamp) last_dt, serial_number
                    FROM meter
                    WHERE serial_number NOT IN('', '/', 0.0, '0000000000')
                    AND date_timestamp > '2023-07-01 00:00:00'
                    GROUP BY serial_number ORDER BY serial_number) last_read
        ON last_read.serial_number = cd.SerialNumber;