project 3 case 1

is this query right now ? select j as numberofjobsreviewperhour, a as timetaken from (select count(jobid) as j, day(ds) as day, (sum(timespent)/3600) as a from jobdata where ds between '2020-11-01' and '2020-11-30' group by day_ )asd;