You can place a ScalarSubquery anywhere an Expression is
permitted. A ScalarSubquery turns a SelectExpression result
into a scalar value because it returns only a single row and column value.
The
query must evaluate to a single row with a single column.
Expression
subquerySometimes also called an expression subquery.