Pergunta de entrevista da empresa MyGlamm

SQL: SQL join (difference between inner and left), aggregate(was answering him using mongo - but he denied), emp name of second highest salary from two tables emp & salary