All ideas
Need to confirm if the query is correct
I have a query regarding Project 3; question 1. Can you confirm if the below query is correct? SELECT ds,COUNT(jobid) AS jobsperday, CAST(SUM(timespent) AS DECIMAL)/3600 AS hours_spent FROM job_data WHERE ds >='2020-11-01' AND ds <='2020-11-30' GROUP BY ds; I am getting the below output.
