Grouping together
In this final exercise, you will combine GROUP BY with aggregate functions such as MIN that you've seen earlier in this chapter.
To conclude this chapter, we'll return to the eurovision table from the first chapter.
Latihan ini adalah bagian dari kursus
Introduction to SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Retrieve the minimum and maximum place, and point values
SELECT
-- the lower the value the higher the place, so MIN = the highest placing
MIN(place) AS hi_place,
___(place) AS lo_place,
-- Retrieve the minimum and maximum points values. This time MIN = the lowest points value
___(points) AS min_points,
MAX(points) AS max_points
FROM
eurovision;