diff options
| author | Santo Cariotti <santo@dcariotti.me> | 2021-02-09 20:35:03 +0000 |
|---|---|---|
| committer | Santo Cariotti <santo@dcariotti.me> | 2021-02-09 20:35:03 +0000 |
| commit | 5ec97dc1ea4a8eec206a908cbb2b8552301a7f35 (patch) | |
| tree | 4c5c38ca29b713d1c6553a45e9afa1c6a0191655 /Year_2/Databases/libri_ex2.xquery | |
| parent | c670e0583e5468646ab42903c95a80662d96cc89 (diff) | |
databases: xml exercise
Diffstat (limited to 'Year_2/Databases/libri_ex2.xquery')
| -rw-r--r-- | Year_2/Databases/libri_ex2.xquery | 9 |
1 files changed, 9 insertions, 0 deletions
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> |