Bases de Données / Databases

Site Web de l'équipe BD du LIP6 / LIP6 DB Web Site

Outils pour utilisateurs

Outils du site


site:enseignement:master:mlbda:tmes:xquery:resultats

Résultat requêtes Xmark

1. Le nom de la personne dont l'identifiant est “person0”.

<name>Xiulin Poch</name>

2.La valeur initiale des trois premières enchères en cours.

<result id="open_auction0">
  <initial>112.22</initial>
</result>
<result id="open_auction1">
  <initial>145.44</initial>
</result>
<result id="open_auction2">
  <initial>93.60</initial>
</result>

3. La valeur de la première et de la dernière augmentation effectuée sur les trois premières des enchères en cours.

<result id="open_auction0">
  <first>18.00</first>
  <last>3.00</last>
</result>
<result id="open_auction1">
  <first>7.50</first>
  <last>6.00</last>
</result>
<result id="open_auction2">
  <first>4.50</first>
  <last>6.00</last>
</result>

4.Le nom et le prix des objets vendus à plus de 480.

<result>
  <name>sing</name>
  <price>482.90</price>
</result>
<result>
  <name>dirt</name>
  <price>617.31</price>
</result>
<result>
  <name>dearest fitting rocks</name>
  <price>594.95</price>
</result>
<result>
  <name>thing fetches contrary</name>
  <price>534.37</price>
</result>
<result>
  <name>lick gracious safety</name>
  <price>494.66</price>
</result>

5.Le noms des objets du continent africain.

<name>duteous nine eighteen</name>
<name>condemn</name>
<name>earnestly subtle spotted attend</name>
<name>poisons</name>
<name>thought inland different</name>
<name>approves</name>
<name>disguise engross hero restraint</name>
<name>renown stained entrails bone</name>
<name>irrevocable holding succeeding</name>
<name>unloose freshness swallowing</name>
<name>parson sure heavy</name>
<name>henceforward decreed</name>
<name>contain spring fate rebellious</name>
<name>sour</name>
<name>canonized piece</name>
<name>truths</name>
<name>forced strangle violence apprehends</name>
<name>sleeps</name>
<name>nev puts</name>
<name>hie stirr divine niece</name>
<name>fie carrying cassio</name>
<name>bestowed liable congruent everything</name>
<name>foot</name>
<name>bewitched proculeius away quoth</name>
<name>greg house turnips</name>
<name>tripp beef prepar</name>
<name>conquer insupportable assurance</name>
<name>perpetual patient company well</name>
<name>fair use conveyance</name>
<name>balthasar bred breathe</name>
<name>villainy</name>
<name>buried ere burst</name>
<name>flourish harms oratory</name>
<name>esteem observance else</name>
<name>lecherous mortal</name>
<name>stake cassandra shake</name>
<name>relate shame pedant flat</name>
<name>prudence jewels deserves sacred</name>

6.Le noms des objets du continent africain avec leur prix de vente

<res>
  <name>condemn</name>
  <price>14.80</price>
</res>
<res>
  <name>thought inland different</name>
  <price>141.43</price>
</res>
<res>
  <name>disguise engross hero restraint</name>
  <price>93.55</price>
</res>
<res>
  <name>irrevocable holding succeeding</name>
  <price>38.59</price>
</res>
<res>
  <name>henceforward decreed</name>
  <price>174.92</price>
</res>
<res>
  <name>truths</name>
  <price>109.40</price>
</res>
<res>
  <name>nev puts</name>
  <price>68.19</price>
</res>
<res>
  <name>hie stirr divine niece</name>
  <price>43.54</price>
</res>
<res>
  <name>bewitched proculeius away quoth</name>
  <price>35.75</price>
</res>
<res>
  <name>greg house turnips</name>
  <price>80.08</price>
</res>
<res>
  <name>tripp beef prepar</name>
  <price>4.00</price>
</res>
<res>
  <name>conquer insupportable assurance</name>
  <price>249.85</price>
</res>
<res>
  <name>fair use conveyance</name>
  <price>34.71</price>
</res>
<res>
  <name>balthasar bred breathe</name>
  <price>63.02</price>
</res>
<res>
  <name>buried ere burst</name>
  <price>1.90</price>
</res>
<res>
  <name>flourish harms oratory</name>
  <price>54.38</price>
</res>
<res>
  <name>lecherous mortal</name>
  <price>133.49</price>
</res>
<res>
  <name>prudence jewels deserves sacred</name>
  <price>66.68</price>
</res>

7. Le nombre de personnes qui ont pas de page web

874
site/enseignement/master/mlbda/tmes/xquery/resultats.txt · Dernière modification: 22/11/2023 11:30 par amine