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.
Este exercício faz parte do curso
Writing Functions and Stored Procedures in SQL Server
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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);