EXL Service Interview Question

SQL questions regarding distinction between two similar syntaxes.