Get startedGet started for free

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

View Course

Exercise instructions

  • Declare @Borough as a nvarchar(30) variable and set it to 'Manhattan'.
  • Pass @Borough to execute the dbo.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
	___ = ___;
Edit and Run Code