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.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Create a function named
SumStationStats
that has one input parameter of typedatetime
-@StartDate
- and returns aTABLE
data type. - Calculate the total
RideCount
usingCOUNT()
andID
. - Calculate the
TotalDuration
usingSUM()
andDURATION
. - Group by
StartStation
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- 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
___ ___ ___;