Why the part that circled works?
I wrote the query in a different way like: I got error code 1064
write like this is correct. I knew that I write the query in this way wouldn’t get client_id 4 in the result but I just wonder why the (SELECT alias - alias) is accepted in the first pic but (SELECT alias-alias) is wrong in the second picture