From bcf585b1cfba4354989c828a3ecb3168f3eae8b9 Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Sat, 6 Feb 2021 22:16:00 +0100
Subject: databases: ex 3

---
 Year_2/Databases/university_marks_ex3.xquery | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 Year_2/Databases/university_marks_ex3.xquery

(limited to 'Year_2/Databases/university_marks_ex3.xquery')

diff --git a/Year_2/Databases/university_marks_ex3.xquery b/Year_2/Databases/university_marks_ex3.xquery
new file mode 100644
index 0000000..dd1f5b8
--- /dev/null
+++ b/Year_2/Databases/university_marks_ex3.xquery
@@ -0,0 +1,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>
-- 
cgit v1.2.3-71-g8e6c