Which day of week is busiest?
Now that we verified there are seconds consistently in our dataset we can calculate the Total Trip Time for each day of the week.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Use
DATENAME()
toSELECT
theweekday
value for theStartDate
. - Use
SUM()
andDATEDIFF()
to calculateTotalTripHours
. (beginning with seconds). - Group by the
DATENAME()
result and summarizeTotalTripHours
. - Order
TotalTripHours
in descending order.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
-- Select the day of week value for StartDate
___(___, StartDate) as DayOfWeek,
-- Calculate TotalTripHours
___(___(___, StartDate, EndDate))/ 3600 as TotalTripHours
FROM CapitalBikeShare
-- Group by the day of week
GROUP BY ___(___, StartDate)
-- Order TotalTripHours in descending order
ORDER BY ___ DESC