datacamp-logo
Course Outline
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.
    Take Hint (-30 XP)