EXL Service interview question

SQL questions regarding distinction between two similar syntaxes.