The department with no employee

Question

Accepted Answer

RIGHT JOIN keeps every row from the right table (departments) regardless of whether a match exists on the left. Sales matches Alice. Eng has no matching employee, so e.name is NULL in that row. RIGHT JOIN is less common in practice - most developers rewrite it as a LEFT JOIN by swapping table order.