We use analytics and advertising cookies to understand how the site is used and whether our ads on Facebook and Instagram work. They are set only if you accept. See our Privacy Policy for details.
Using a set operation, return a single distinct 'name' column combining all Engineering employees (department_id = 1) with all employees earning more than 100000. Use UNION so anyone in both lists appears once.