Transactions per day
It's time for you to do some temporal EDA on the BikeShare dataset. Write a query to determine how many transactions exist per day.
Sometimes datasets have multiple sources and this query can help you understand if you are missing data.
Questo esercizio fa parte del corso
Writing Functions and Stored Procedures in SQL Server
Istruzioni dell'esercizio
- Use
CONVERT()toSELECTandGROUP BYthe date portion of theStartDate. - Use
COUNT()to measure how many records exist for eachStartDate. - Sort the results by the date portion of
StartDate.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT
-- Select the date portion of StartDate
___(___, StartDate) as StartDate,
-- Measure how many records exist for each StartDate
___(___) as CountOfRows
FROM CapitalBikeShare
-- Group by the date portion of StartDate
___ BY ___(___, StartDate)
-- Sort the results by the date portion of StartDate
___ BY ___(___, StartDate);