Case study 1 project 3

the Atrribute DS is of date type and the question says that we need to find out the Jobs Reviewed Over Time: Objective: Calculate the number of jobs reviewed per hour for each day in November 2020. Your Task: Write an SQL query to calculate the number of jobs reviewed per hour for each day in November 2020. how can we calculate for per hour if it is not given these are the attributes and there data type job_id: Unique identifier of jobs actor_id: Unique identifier of actor event: The type of event (decision/skip/transfer). language: The Language of the content time_spent: Time spent to review the job in seconds. org: The Organization of the actor ds: The date in the format yyyy/mm/dd (stored as text).