Exercise

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.

Instructions

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