1. सीखें
    2. /
  2. पाठ्यक्रम
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

अभ्यास

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.

निर्देश

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.