{ let $doc := doc('all.xml') for $pattern in distinct-values($doc//model/name/prosite) let $auc := max($doc//model[name/prosite=$pattern]/auc) let $zauc := max($doc//model[name/prosite=$pattern]/zauc) let $ppv := max($doc//model[name/prosite=$pattern]/prosite/ppv) order by $pattern return {$pattern} {$auc} {$zauc} {$ppv} }