diff options
Diffstat (limited to 'Year_2/Databases/verbale_ex1.xquery')
-rw-r--r-- | Year_2/Databases/verbale_ex1.xquery | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/Year_2/Databases/verbale_ex1.xquery b/Year_2/Databases/verbale_ex1.xquery new file mode 100644 index 0000000..2be6f06 --- /dev/null +++ b/Year_2/Databases/verbale_ex1.xquery @@ -0,0 +1,18 @@ +<ex1> +{ +let $f := doc("verbale.xml") +for $verbale in $f//verbale +where $verbale/studente[@cdl="667"] and $verbale/esame/materia/text()="Reti di Calcolatori" +return <voto> + <valore> + { + $verbale/esame/voto/text() + } + </valore> + {if ($verbale/esame/lode) then ( + <lode>Y</lode> + ) else () } + </voto> + +} +</ex1> |