ORA-00937: Not a single-group group function
The SELECT list mixes a group function with a plain column but there is no GROUP BY. Either add the plain columns to GROUP BY, or remove them.
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.