I want to create the script (Within prompt )so that I can limit the values of employee location name as per employee location country. I have created the below mentioned script however the script populate the country name instead of limiting location name as per country.

SELECT Distinct"Employee Location"."Employee
Location Name" FROM "Human Resources - Workforce Profile" where "Employee
Location"."Employee Location Country Name " IN (SELECT
"Employee Location"."Employee Location Country Name" FROM
"Human Resources - Workforce Profile")FETCH FIRST 65001 ROWS
ONLY