BIP – Extract list of counties for GB

Below SQL can be used to extract list counties configured for GB in HCM:

SELECT *
  FROM fusion.hz_geographies hg
 WHERE hg.geography_type = 'COUNTY'
   AND country_code= 'GB'
 ORDER BY geography_name