Pergunta de entrevista da empresa Agilent Technologies

Can you write a SQL query to find the second highest salary in a table? How would you join two tables and filter results based on a specific condition? Explain the difference between INNER JOIN, LEFT JOIN, and RIGHT JOIN.