This explains how to use the GROUP BY clause to manipulate data on rows with the SELECT statement applied to a table using SQL Oracle Developer connected to an Oracle database version 18c.
It also explains the use of GROUP functions, which are closely related to GROUP BY.
The group functions are:
MIN
MAX
AVG
SUM
COUNT