employees → This table stores employees id, name, salary, and department_id. departments → This table stores department id and name. Use scalar subqueries for single-value results. Use IN and EXISTS ...