INVALID_SUBQUERY_EXPRESSION error condition

SQLSTATE: 42823

Invalid subquery:

SCALAR_SUBQUERY_RETURN_MORE_THAN_ONE_OUTPUT_COLUMN

Scalar subquery must return only one column, but got <number>.

STREAMING_QUERY

Streaming query is not allowed in subquery expressions.