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.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Declare
@Borough
as anvarchar(30)
variable and set it to'Manhattan'
. - Pass
@Borough
to execute thedbo.cuspPickupZoneShiftStats
stored procedure. - Admire your work. :)
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create @Borough
___ ___ AS ___(___) = '___'
-- Execute the SP
___ ___.___
-- Pass @Borough
___ = ___;