The GROUP BY clause is used with aggregate functions, such as MIN() and MAX(), and with the WHERE, HAVING, and ORDER BY clauses. The examples in this video use full column names, aliases, and column numbers. The HAVING clause filters the results of the GROUP BY and the aggregate functions. The clauses are specified in SQL in a specific order.
Source: Sven Aelterman, https://www.youtube.com/watch?v=7muNG423Cjs
This work is licensed under a Creative Commons Attribution 3.0 License.
Last modified: Monday, October 11, 2021, 11:00 AM