1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

Bài tập

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.

Hướng dẫn

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. :)