From 5ec97dc1ea4a8eec206a908cbb2b8552301a7f35 Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Tue, 9 Feb 2021 21:35:03 +0100
Subject: databases: xml exercise

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

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

diff --git a/Year_2/Databases/libri_ex2.xquery b/Year_2/Databases/libri_ex2.xquery
new file mode 100644
index 0000000..e20b41f
--- /dev/null
+++ b/Year_2/Databases/libri_ex2.xquery
@@ -0,0 +1,9 @@
+let $f := doc("libri.xml")
+let $authors := $f//autore
+
+for $author in distinct-values($authors)
+let $books := $f//libro[autore=$author]
+return <author>
+            <name>{ $author }</name>
+            <num>{ count($books) }</num>
+       </author>
-- 
cgit v1.2.3-71-g8e6c