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

övning

Logical weekdays with Hot Deck

Calculate Total Fare Amount per Total Distance for each day of week. If the TripDistance is zero use the Hot Deck imputation function you created earlier in the chapter.

Instruktioner

100 XP
  • Use DATENAME() and PickupDate to select the day of week.
  • Use AVG() to calculate TotalAmount per TripDistance, and a CASE statement to select TripDistance if it's more than 0. If not, use dbo.GetTripDistanceHotDeck().
  • Order by the PickupDate day of week, with 'Monday' appearing first.