1789. Primary Department for Each Employee

• 문제
  
• 정답

SELECT employee_id, department_id
FROM Employee 
WHERE primary_flag='Y' OR employee_id IN
(SELECT employee_id
FROM Employee
GROUP BY employee_id
HAVING COUNT(employee_id)=1)

• 결과