project 3, case study 1

is this query right ? select j as numberofjobsreviewperhour, a as timetaken from (select count(jobid) as j, day(ds) as day, sectotime(sum(timespent)) as a from jobdata group by day_ )asd; and if not how to get job review per hour if here data is provided for seconds ?