Code:
xquery version "1.0";
let $count := 0
for $dept in doc("store.xml")/root/dept
return
<total_items>
{
<name>{ $dept/name/text() }</name>,
<count>
{
if (contains($dept/toys, "test"))
Leave a comment: