Pickup locations by shift results
Let's see the AvgFarePerKM,RideCount and TotalRideMin for the pickup locations within Manhattan during the different driver shifts of each weekday.
Bu egzersiz, kursun bir parçasıdır
Writing Functions and Stored Procedures in SQL Server
Egzersiz talimatları
- Declare
@Boroughas anvarchar(30)variable and set it to'Manhattan'. - Pass
@Boroughto execute thedbo.cuspPickupZoneShiftStatsstored procedure. - Admire your work. :)
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
-- Create @Borough
___ ___ AS ___(___) = '___'
-- Execute the SP
___ ___.___
-- Pass @Borough
___ = ___;