Guest User

Untitled

a guest
Apr 20th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.34 KB | None | 0 0
  1.  SELECT DISTINCT k.name AS kino
  2.    FROM film.vorstellung f1
  3.    JOIN film.kino k ON k.id = f1.kino
  4.   WHERE NOT (EXISTS ( SELECT f.id, f.titel, f.jahr, f.fsk
  5.       FROM film.film f
  6.      WHERE f.jahr >= 1992 AND f.jahr <= 1994 AND NOT (f.id IN ( SELECT f2.film
  7.               FROM film.vorstellung f2
  8.              WHERE f1.kino = f2.kino))));
Add Comment
Please, Sign In to add comment