2
The most immediate reason your attempt did not work was because it was syntactically invalid.
You can use the result of a SELECT statement as a scalar value in an expression but you must enclose the said SELECT statement in parentheses. In your case, there are two such SELECT statements. Below is your attempted query slightly reformatted for readability ...
Only top voted, non community-wiki answers of a minimum length are eligible
