Infosys Interview Question

SQL question, code explanation and question related to resume