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.

Bu egzersiz, kursun bir parçasıdır

Writing Functions and Stored Procedures in SQL Server

Kursa Göz Atın

Egzersiz talimatları

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.

Uygulamalı etkileşimli egzersiz

Bu egzersizi bu örnek kodu tamamlayarak deneyin.

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);

Kodu Düzenle ve Çalıştır