1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Functions and Stored Procedures in SQL Server

Exercise

Test FUNCTIONs

Now it's time to test the three functions you wrote in the previous exercise.

Instructions

100 XP
  • Display the first 100 records of PickupDate, TripDistance and FareAmount from YellowTripData.
  • Determine the shift value of PickupDate by passing the hour value to dbo.GetShiftNumber function; display the shift and include it in the WHERE clause for shifts = 2 only.
  • Convert TripDistance to kilometers with dbo.ConvertMiletoKm function.
  • Convert FareAmount to Euro (with exchange rate of 0.87) with the dbo.ConvertDollar function.