✅ SQL Interview Challenge! 🧠💻

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: Find all employees who *don’t have a manager* (i.e., manager_id is NULL) and list their names and departments.

𝗠𝗲: Using WHERE with IS NULL:

SELECT name, department
FROM employees
WHERE manager_id IS NULL;

✔ Why it works:
– IS NULL filters rows where manager_id is missing.
– Simple and fast for identifying top-level employees in an organization.

🔎 Bonus Tip: Combine with LEFT JOIN to also include department names from another table if needed.

💬 Tap ❤️ if this helped you!