𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: Write a query to get the names of all employees along with their department names. If an employee is not assigned to a department, still include them.

𝗠𝗲: Here’s my SQL solution using a LEFT JOIN:

SELECT e.name AS employee_name, d.name AS department_name
FROM employees e
LEFT JOIN departments d ON e.department_id = d.id;

✔ Why it works:
– LEFT JOIN ensures all employees are shown, even those without departments.
– It joins the employees and departments tables on department_id.
– Clean, readable, and interview-ready!

🔎 Bonus Insight:
Always understand the difference between INNER JOIN, LEFT JOIN, and RIGHT JOIN. In real-world databases, missing data is common — use joins wisely to handle it.

💬 Tap ❤️ if this helped you!