What are the names of departments that have at least one employee.
SELECT DISTINCT T2.department_name FROM employees AS T1 JOIN departments AS T2 ON T1.department_id  =  T2.department_id
departments that have at least one employee requires a JOIN between employees and departments table on department_id; names of such departments refers to department_name; DISTINCT is used to ensure department names are not repeated.