IE-TN Data

cities.xqy

xquery version "3.0";
<cities>{
    let $names :=
        "Adelaide
        Adelaide
        Adelaide and Windsor
        Adelaide Station
        Agangarrive Hill
        Aghadovey
        Aghadowey
        Aghagallon"
    let $names := fn:tokenize($names,"&#10;")
    for $city in fn:distinct-values($names)
    return
  <city location="IE">{$city}</city>
}</cities>

count.xqy

xquery version "3.0";

fn:count(fn:collection()/cities/city[@location="TN"])

match.xqy

xquery version "3.0";

let $tn := /cities/city[@location="TN"]
let $ie := /cities/city[@location="IE"]
for $city in $ie
where $city[. = $tn]
order by $city
return $city

matches.xml

<city location="IE TN">Ardmore</city>
<city location="IE TN">Balmoral</city>
<city location="IE TN">Barr</city>
<city location="IE TN">Belfast</city>
<city location="IE TN">Belmont</city>
<city location="IE TN">Cave Hill</city>
<city location="IE TN">Church Hill</city>
<city location="IE TN">Clover Hill</city>
<city location="IE TN">Coney Island</city>
<city location="IE TN">Cross Roads</city>
<city location="IE TN">Fairfield</city>
<city location="IE TN">Granville</city>
<city location="IE TN">Holly Hill</city>
<city location="IE TN">Holy Hill</city>
<city location="IE TN">Hunters Point</city>
<city location="IE TN">Jonesborough</city>
<city location="IE TN">Long Rock</city>
<city location="IE TN">Milltown</city>
<city location="IE TN">Mount Ida</city>
<city location="IE TN">Mount Pleasant</city>
<city location="IE TN">Newcastle</city>
<city location="IE TN">Newtown</city>
<city location="IE TN">Rich Hill</city>
<city location="IE TN">Riverside</city>
<city location="IE TN">Roe</city>
<city location="IE TN">Spring Hill</city>
<city location="IE TN">Springfield</city>
<city location="IE TN">Warren</city>
<city location="IE TN">Whitehead</city>
<city location="IE TN">Whitehouse</city>