Oracle Programming/Reporting Aggregated Data Using the Group Functions

Identifying the available group functions

Describing the use of group functions

Grouping data by using the GROUP BY clause

Including or excluding grouped rows by using the HAVING clause