I guess there is something wrong with this question as it should be like follows:
SELECT X AS 'Except'
FROM A
EXCEPT
SELECT Y
FROM B
but maybe the author took it copy/paste from his 1st question and forgot to change the code.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant