Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --e;
- SELECT d.klantnr, k.naam ,d.reisnr, b.objectnaam,( SELECT COUNT(*)
- FROM hemelobjecten
- WHERE b.objectnaam = hemelobjecten.satellietvan) AS aantal
- FROM klanten k
- INNER JOIN deelnames d ON(k.klantnr = d.klantnr)
- INNER JOIN bezoeken b ON (d.reisnr = b.reisnr)
- INNER JOIN hemelobjecten h ON(b.objectnaam = h.objectnaam)
- WHERE h.objectnaam SIMILAR TO '(M|N)%s'
- AND naam SIMILAR TO '_(a|e|i|o|u)%'
- AND k.geboortedatum > '1974-12-31'
- AND k.geboortedatum < '1976-01-01'
- GROUP BY d.klantnr, k.naam, d.reisnr, b.objectnaam
- HAVING EXISTS (SELECT *
- FROM hemelobjecten
- WHERE b.objectnaam = satellietvan)
- ORDER BY d.klantnr;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement