By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Msg 512 Level 16 State 1 Line 6
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.