BaşlayınÜcretsiz Başlayın

Test FUNCTIONs

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

Bu egzersiz

Writing Functions and Stored Procedures in SQL Server

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • 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.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT
	-- Select the first 100 records of PickupDate
	TOP 100 ___,
    -- Determine the shift value of PickupDate
	dbo.___(___(___, ___)) AS 'Shift',
    -- Select FareAmount
	FareAmount,
    -- Convert FareAmount to Euro
	dbo.___(___, 0.87) AS 'FareinEuro',
    -- Select TripDistance
	TripDistance,
    -- Convert TripDistance to kilometers
	dbo.___(___) AS 'TripDistanceinKM'
FROM YellowTripData
-- Only include records for the 2nd shift
WHERE dbo.___(___(___, ___)) = 2;
Kodu Düzenle ve Çalıştır