select all fields from call_report where call_date is in this month or in last month
T * FROM call_report WHERE call_date BETWEEN '2018-01-01' AND '2018-01-31'; I want to get the sum of the call_time column for each day in the date range. I tried the following query but it doesn't work. SELECT DATE(call_date) AS date, SUM(call_time) AS total_time FROM call_report WHERE call_date BETWEEN '2018-01-01'