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

Exercise

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?

Instructions

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.