I have actually developed this query as follows, but not I get the following error message:

Subquery returned more than 1 value. This is not permitted when the subquery follows =,...