| (: insert-start :) | |
| declare variable $input-context1 external; | |
| declare variable $input-context2 external; | |
| (: insert-end :) | |
| <result> | |
| { | |
| for $uid in distinct-values($input-context1//userid), | |
| $u in $input-context2//user_tuple[userid = $uid] | |
| let $b := $input-context1//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> |