Message Oracle QSM-02145 - GROUP BY clause is present but no aggregate functions are used

ERRORGROUP BY clause is present but no aggregate functions are used
CAUSEA GROUP BY clause is used but no aggregate functions are present in the select list.
ACTIONAdd an aggregate function to the select list.