ORA-01427: Single-row subquery returns more than one row
A subquery used with =, <, > or in the SELECT list must return at most one row. Use IN, = ANY or > ALL for several rows, or make the subquery return one row.
On the exam
This error belongs to the topic Subqueries 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.