The SQL query uses a subquery that returns multiple rows when only one row is expected. This can lead to unexpected results or errors, depending on the database system.

The SQL query uses a subquery that returns more than one ... It should be rewritten to handle cases where the subquery might return multiple rows, such as by using aggregation functions or joining ...