write a query to display day and the total_units of electricity consumed on each day between the dates '2018-05-06' and '2018-05

Question

Sql

Answer 1

SELECT day, unit, SUM(unit) AS total_units FROM tableName WHERE date BETWEEN startDate AND endDate

Answer 2

No it not working

Answer 3

Probably cause date is not working with between.

Answer 4

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_between_date&ss=-1