The avg function is used to get the average of total items present in a sequence.
avg($seq as item()*)
$seq − provided sequence. A sequence can contain 0 or more items.
let $items := (1,2,3,4,5,6) let $avg := avg($items) return <result> <avg>{$avg}</avg> </result>
<result> <avg>3.5</avg> </result>
In order to test the above-mentioned functionality, replace the contents of books.xqy (mentioned in Environment Setup chapter) with the above XQuery expression and execute the XQueryTester java program to verify the result.