Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT k.name AS kino
- FROM film.vorstellung f1
- JOIN film.kino k ON k.id = f1.kino
- WHERE NOT (EXISTS ( SELECT f.id, f.titel, f.jahr, f.fsk
- FROM film.film f
- WHERE f.jahr >= 1992 AND f.jahr <= 1994 AND NOT (f.id IN ( SELECT f2.film
- FROM film.vorstellung f2
- WHERE f1.kino = f2.kino))));
Add Comment
Please, Sign In to add comment