SQL Query to get City, County, State, Zip Code

SELECT geography_element4 city, geography_element3 county,
       geography_element2_code state, geography_element5 zip_code,
       geography_element1_code country
  FROM hz_geographies
 WHERE geography_element5_id = geography_id AND geography_element1_code = 'US';