LumenData Interview Question

SQL Technical: "How do you handle duplicates in a dataset using SQL?" "Explain the difference between JOIN and UNION with a real-world example." "Write a query to find the second highest salary/value in a table."