Contents

<result>
 {
    for $uid in distinct-values(doc("bids.xml")//userid),
        $u in doc("users.xml")//user_tuple[userid = $uid]
    let $b := doc("bids.xml")//bid_tuple[userid = $uid]
    order by $u/userid
    return
        <bidder>
            { $u/userid }
            { $u/name }
            <bidcount>{ count($b) }</bidcount>
            <avgbid>{ avg($b/bid) }</avgbid>
        </bidder>
  }
</result>

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
magic_xml-0.1.1	xquery_use_cases/rdb/q13.xquery
magic_xml-0.1.0	xquery_use_cases/rdb/q13.xquery