Question

10. Google and learn about the SQL functions Datepart and Datename. Use this function to show the number of employees hired by day of the week weekday number of hires 42 1 2 42 2 3 3 31 4 47 5 43 49 6 6 36 7 7 Or weekday number of hires Friday 49 42 Monday 36 Saturday 4 Sunday 42 5 Thursday 43 Tuesday 31 47 7 Wednesday 123 L o

Answer 1

If you have any doubts, please give me comment...

By using DATEPART:

SELECT DATEPART(w, HireDate) AS 'weekday', COUNT(*) AS 'number of hires'

FROM Employee

GROUP BY DATEPART(w, HireDate);

By using DATENAME:

SELECT DATENAME(w, HireDate) AS 'weekday', COUNT(*) AS 'number of hires'

FROM Employee

GROUP BY DATENAME(w, HireDate);