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.

Cet exercice fait partie du cours

<cours>Writing Functions and Stored Procedures in SQL Server</cours>

Voir le cours

Instructions de l’exercice

Declare @Borough as a nvarchar(30) variable and set it to 'Manhattan'.
Pass @Borough to execute the dbo.cuspPickupZoneShiftStats stored procedure.
Admire your work. :)

Exercice interactif pratique

Essayez cet exercice en complétant ce code d’exemple.

-- Create @Borough
___ ___ AS ___(___) = '___'
-- Execute the SP
___ ___.___
    -- Pass @Borough
	___ = ___;

Modifier et exécuter le code