TrainityTrainity
All ideas

Project 3, Case Study 1: Job Data Analysis

Is this solution I have come up with correct? /* 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. */ Solution: SELECT ds AS dayinnovember, COUNT(jobid)/(SUM(timespent)/3600) AS jobsreviewedper_hr FROM job_data GROUP BY ds; Here, I am trying to derive the jobs reviewed per hour by dividing the count of job IDs by the total time spent in a day in hours.