//opg1
select personNo, firstName, lastName, zipcode
from
person

//opg2
Select firstName, address, zipCode
from
person
where
zipCode=5000

//opg3
Select *
from
person
where
zipCode=5492

//opg4
Select firstName, lastName, z1.zipCode
from
person p1, ZipDistrict z1
where z1.district like 'Odense%'

//opg5
Select firstName, lastName 
from
person
where Person.lastName = 'Larsen'
ORDER BY firstName

//opg 6
Select firstName, lastName, z1.zipCode, district
from
person p1, ZipDistrict z1
where
p1.zipCode=z1.zipCode
ORDER BY lastName, firstname asc

//opg 7
select firstName, lastName 
from person p1, Chairman c1
where p1.personNo= c1.personNo

//opg 8
Select firstName, lastName, departmentName
from person p1, Chairman c1, Department d1
where p1.personNo= c1.personNo and c1.departmentId =d1.departmentId

//opg 9
Select firstName, lastName, d1.departmentId
from person p1, Chairman c1, Department d1, ZipDistrict z1
where z1.district like 'Odense%' and p1.personNo= c1.personNo and c1.departmentId =d1.departmentId and p1.zipCode =z1.zipCode

//opg 10
SELECT COUNT(firstname) FROM person

//opg 11
SELECT COUNT(firstname)
from person p1, Member m1, Department d1
where p1.personNo= m1.personNo and m1.departmentId =d1.departmentId

//opg 12
SELECT COUNT(firstname)
from person p1, Member m1, Department d1, Team t1
where p1.personNo= m1.personNo and m1.departmentId =d1.departmentId and t1.departmentId = d1.departmentId

// opg 13
Select departmentName, COUNT(m1.personno) 'Antal'
from person p1, Member m1, Department d1
where p1.personNo= m1.personNo and m1.departmentId =d1.departmentId
Group by departmentName

// opg 14
Select departmentName
from person p1, Department d1, Chairman c1
where p1.personNo= c1.personNo and c1.departmentId =d1.departmentId
Group by departmentName

//opg 15 // virker ikke
Select d1.departmentName
from person p1, Department d1, Member m1, Chairman c1
where d1.departmentId <> c1.departmentId and m1.personNo <> c1.personNo and p1.personNo= m1.personNo and m1.departmentId <> c1.departmentId and  c1.departmentId <>d1.departmentId

opg 16
Select d1.departmentName, p1.firstName
from person p1, Department d1, Chairman c1, Member m1
where c1.departmentId =d1.departmentId and m1.departmentId =d1.departmentId and m1.personNo = p1.personNo

opg 17
select p1.address, zipCode, firstname
from person p1
where p1.address !< 2