LeoWoerteler

group: cddb
description[[This data set models music released on CDs.
It contains information about CDs in the 'alternative' genre released between 1956 and 2005 extracted from FreeDB.

https://musicbrainz.org/doc/FreeDB
]]

cds = {cdid:number,artist2albumid:number,ayear:number,discid
"162","162",2003,"0200ee01"
"163","163",2000,"0200f001"

LeoWoerteler

group: corporation example
description[[
bla blubb
]]

DEPT = {
DEPTNO:number, DNAME:string, LOC:string
10, 'ACCOUNTING', 'NEY YORK'
20, 'RESEARCH', 'DALLAS'
30, 'SALES', 'CHICAGO'

LeoWoerteler

Crime ID,Month,Reported by,Falls within,Longitude,Latitude,Location,LSOA code,LSOA name,Crime type,Last outcome category,Context
0f9c1f736d68277b21ca32eb1e6cebb0f27856239453adfea213a849a760bfc5,2016-09,City of London Police,City of London Police,-0.106453,51.518207,On or near Charterhouse Street,E01000916,Camden 027B,Violence and sexual offences,Status update unavailable,
,2016-09,City of London Police,City of London Police,-0.112422,51.515381,On or near Star Yard,E01000914,Camden 028B,Anti-social behaviour,,
2af4ca2def4379aa0d08f84ecfc0cca6838f7da0f81a4d9ed902d4648c21ee45,2016-09,City of London Police,City of London Police,-0.113767,51.517372,On or near Stone Buildings,E01000914,Camden 028B,Bicycle theft,Investigation complete; no suspect identified,
894eae55565baaa777ce68ffe51bccc60c9608a6ca236a9487a5ea78084e7fdc,2016-09,City of London Police,City of London Police,-0.113767,51.517372,On or near Stone Buildings,E01000914,Camden 028B,Other theft,Investigation complete; no suspect identified,
,2016-09,City of 

LeoWoerteler

(: list of all persons and their neighbors :)
declare variable $persons :=
  for $scene in doc('http://www.ibiblio.org/xml/examples/shakespeare/r_and_j.xml')//SCENE
  let $speakers := distinct-values($scene/SPEECH/SPEAKER)
  for $p1 in $speakers, $p2 in $speakers
  where $p1 ne $p2
  group by $p1
  return <person name="{$p1}">{
    for $other in distinct-values($p2)

LeoWoerteler

<?xml version="1.0" encoding="UTF-8"?>
<iso_3166-1>
  <country numeric="004" alpha-3="AFG" alpha-2="AF">
    <name language="en">Afghanistan</name>
    <name language="fr">Afghanistan (l')</name>
  </countr>
  <country numeric="248" alpha-3="ALA" alpha-2="AX">
    <name language="en">Åland Islands</name>
    <name language="fr">Åland(les Îles)</name>
  </country>