Getting same geography code for different city under same state and county
Getting same geography code for different city under same state and county, i am expecting unique city code for all cities under same county and state. i am using below query, please let me know if my understanding is correct or any issue with the code?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT st_name.identifier_value CITY,
FROM hz_geographies state_geo
WHERE state_geo.geography_type = 'CITY'