Pergunta de entrevista da empresa EXL Service

SQL questions regarding distinction between two similar syntaxes.