summaryrefslogtreecommitdiff
path: root/Year_2/Databases/university_marks_ex3.xquery
blob: dd1f5b842e148560a0895e6c7cf1f1732ba3780c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<ex3>
{
let $f := doc("university_marks.xml")
let $courses := distinct-values($f//materia)

for $course in $courses
return <course area="{$course}">
    {
    for $data in $f//libretto
    where $data//esami//esame//materia/text()=$course
    return <student>{$data//studente/@matricola}</student>
    }
    </course>
}
</ex3>