Title: Construct SQL code by applying a GROUP BY clause that uses column, alias, and number.
Course: Database Design and Management (Oracle) (10052) > Section: Aggregating Data Using GROUP Functions

Construction should include applying a GROUP BY clause in a query that uses a group function in the SELECT statement.

- Any column defined in the SELECT clause where a group function is used, that is NOT a group function, must be present in the GROUP BY clause.
- The GROUP BY clause will produce sub-totals on the field defined to group by.