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

अभ्यास

Find the outliers

The previous exercise showed us that Saturday was the busiest day of the month for BikeShare rides. Do you wonder if there were any individual Saturday outliers that contributed to this?

निर्देश

100 XP
  • Use SUM() and DATEDIFF() to find the Total Ride Hours per day starting from seconds.
  • Use CONVERT() to SELECT the date portion of StartDate.
  • Use DATENAME() and CONVERT() to select the WEEKDAY.
  • Use WHERE to only include Saturdays.