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.
Deze oefening maakt deel uit van de cursus
Introduction to SQL Server
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- 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;