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.

Bu egzersiz, kursun bir parçasıdır

Writing Functions and Stored Procedures in SQL Server

Kursa Göz Atın

Egzersiz talimatları

Use DATENAME() to SELECT the weekday value for the StartDate.
Use SUM() and DATEDIFF() to calculate TotalTripHours. (beginning with seconds).
Group by the DATENAME() result and summarize TotalTripHours.
Order TotalTripHours in descending order.

Uygulamalı etkileşimli egzersiz

Bu egzersizi bu örnek kodu tamamlayarak deneyin.

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

Kodu Düzenle ve Çalıştır