SELECT state_province_county FROM addresses WHERE address_id NOT IN (SELECT employee_address_id FROM Employees)
Find the states which do not have any employee in their record.
SELECT state_province_county FROM addresses WHERE address_id NOT IN ( SELECT employee_address_id FROM Employees )
select state_province_county from addresses where address_id not in ( select employee_address_id from employees )
Find the states which do not have any employee in their record .