File: Data.xml
1
name 1
2
name 2
3
name 3
4
name 4
File: Query.xquery
for $d in distinct-values(doc("Data.xml")//car/@dept)
return
count="{count(doc("Data.xml")//car[@dept = $d])}"/>
Output: