select ds, count(jobid) as jobsperday, sum(timespent)/3600 as hours_spent from job_data where ds >='2020-11-01' and ds <='2020-11-30' group by ds; used this but the no. of rows showing in result is 0
