Inline TVF

Create an inline table value function that returns the number of rides and total ride duration for each StartStation where the StartDate of the ride is equal to the input parameter.

Bu egzersiz, kursun bir parçasıdır

Writing Functions and Stored Procedures in SQL Server

Kursa Göz Atın

Egzersiz talimatları

Create a function named SumStationStats that has one input parameter of type datetime - @StartDate - and returns a TABLE data type.
Calculate the total RideCount using COUNT() and ID.
Calculate the TotalDuration using SUM() and DURATION.
Group by StartStation.

Uygulamalı etkileşimli egzersiz

Bu egzersizi bu örnek kodu tamamlayarak deneyin.

-- Create the function
___ ___ SumStationStats(___ AS ___)
-- Specify return data type
___ ___
AS
RETURN
SELECT
	StartStation,
    -- Use COUNT() to select RideCount
	___(___) AS RideCount,
    -- Use SUM() to calculate TotalDuration
    ___(___) AS TotalDuration
FROM CapitalBikeShare
WHERE CAST(StartDate as Date) = @StartDate
-- Group by StartStation
___ ___ ___;

Kodu Düzenle ve Çalıştır