区域地图

MATCH (:Company{name:'NeoDash'})-[:HAS_DEPARTMENT]->(:Department)<-[:IN_DEPARTMENT]-(e:Employee),
(e)-[:LIVES]->(city:City)-[:IN_COUNTRY]->(country:Country)
WITH city, country
CALL {
    WITH country
    RETURN country.countryCode as code, count(*) as value
    UNION
    WITH city
    RETURN city.countryCode as code, count(*) as value
}
WITH code, sum(value) as totalCount
RETURN code,totalCount