select 
  '2015/16' as "Sæson",
  '621211' as Skolekode,
  e.id as Holdelever,
  substring(e.foeddato from 1 for 10) as "Fødselsdato",
  substring(e.foeddato from 1 for 4) as "Årgang", 
  mod(substring(e.cpr from 11 for 1),2) as "Køn",
  e.postnr,
  e.Klassetrin,
  e.Klassespor,
  e.Klassetrin||e.Klassespor as Klasse,
  d.navn as Skoledistrikt,
  h.holdnr,
  substring(eth.tilmeldt from 1 for 10) as Tilmeldt,
  substring(eth.tilmeldt from 6 for 2) as TilmM,
  substring(eth.udmeldt from 1 for 10) as Udmeldt,
  substring(eth.udmeldt from 6 for 2) as UdmM,
  hs.navn as "Holdstatus",
  fk.fagkode,
  fk.subkode as "Fagkode-Niv2",
  fk.beskrivelse as "Fagkode-Tekst",
  s.navn as Undervisningssted,
  s2.navn as Skole,
  a.navn as Afdeling
from elever e
right outer join elevtilhold eth on eth.elevid = e.id
left join hold h on h.id = eth.holdid
left join status hs on hs.id = h.status
left join fagkoder fk on fk.id = h.virksomhedskode
left join skoler s on s.id = h.skoleid
left join skoler s2 on s2.id = e.skole
left join afdeling a on a.id = h.afdeling
left join distrikter d on d.id = e.distrikt