Stepwise-Lab

ORA-00934: Group function is not allowed here

A group function such as COUNT or AVG appears in WHERE (or in GROUP BY). WHERE filters rows before grouping; filter on group results in HAVING instead.

On the exam

This error belongs to the topic Aggregation of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors