1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate SQL Server

Exercise

Creating aggregations

This chapter uses data gathered by the National UFO Reporting Center. The data is contained in the Incidents table and in this lesson, you will be aggregating values in the DurationSeconds column.

Instructions

100 XP

Write a T-SQL query which will return the average, minimum, and maximum values of the DurationSeconds column.