subquery in case statement mysql