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.
Bu egzersiz
Intermediate SQL Server
kursunun bir parçasıdırEgzersiz talimatları
Write a T-SQL query which will return the average, minimum, and maximum values of the DurationSeconds column.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Calculate the average, minimum and maximum
SELECT ___ AS Average,
___ AS Minimum,
___ AS Maximum
FROM Incidents