1. Learn
    2. /
  2. Courses
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

Exercise

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.

Instructions

100 XP
  • Use CONVERT() to SELECT and GROUP BY the date portion of the StartDate.
  • Use COUNT() to measure how many records exist for each StartDate.
  • Sort the results by the date portion of StartDate.