Find the outliers

The previous exercise showed us that Saturday was the busiest day of the month for BikeShare rides. Do you wonder if there were any individual Saturday outliers that contributed to this?

Diese Übung ist Teil des Kurses

Writing Functions and Stored Procedures in SQL Server

Kurs anzeigen

Anleitung zur Übung

Use SUM() and DATEDIFF() to find the Total Ride Hours per day starting from seconds.
Use CONVERT() to SELECT the date portion of StartDate.
Use DATENAME() and CONVERT() to select the WEEKDAY.
Use WHERE to only include Saturdays.

Interaktive Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

SELECT
	-- Calculate TotalRideHours using SUM() and DATEDIFF()
  	___(___(___, StartDate, EndDate))/ 3600 AS TotalRideHours,
    -- Select the DATE portion of StartDate
  	___(___, StartDate) AS DateOnly,
    -- Select the WEEKDAY
  	___(___, ___(___, StartDate)) AS DayOfWeek 
FROM CapitalBikeShare
-- Only include Saturday
WHERE ___(___, StartDate) = 'Saturday' 
GROUP BY CONVERT(DATE, StartDate);

Code bearbeiten und ausführen