what are the distinguishing characteristics of a scalar subquery?
Scalar Subquery Characteristics A scalar subquery returns exactly one row as output. If the scalar subquery finds no match, it returns NULL. If the scalar subquery finds more than one match, it returns an error.