SELECT v.name, a.street, a.nr, a.city
FROM Venues v INNER JOIN Address a ON v.addressId=a.adrressId
WHERE v.venueId IN(
	SELECT s.venueId
	FROM Screenings s
	WHERE s.screeningId IN (
		SELECT ms.screeningId
		FROM Movies_Screenings ms
		WHERE ms.movieId IN (
			SELECT m.movieId
			FROM Movies m
			WHERE m.movieId IN (
				SELECT mg.movieId
				FROM Movies_Genres mg
				WHERE mg.genreId IN(
					SELECT g.genreId
					FROM Genres g
					WHERE g.name = 'Comedy')
				)
			)
		)
	)
) AND v.venueId IN(
	SELECT s.venueId
	FROM Screenings s
	WHERE s.screeningId IN (
		SELECT ms.screeningId
		FROM Movies_Screenings ms
		WHERE ms.movieId IN (
			SELECT m.movieId
			FROM Movies m
			WHERE m.movieId IN (
				SELECT mg.movieId
				FROM Movies_Genres mg
				WHERE mg.genreId IN(
					SELECT g.genreId
					FROM Genres g
					WHERE g.name = 'Drama')
				)
			)
		)
	)
)

















	SELECT s.venueId
	FROM Screenings s
	WHERE s.screeningId IN (
		SELECT ms.screeningId
		FROM Movies_Screenings ms
		WHERE ms.movieId IN (
			SELECT m.movieId
			FROM Movies m
			WHERE m.movieId IN (
				SELECT mg.movieId
				FROM Movies_Genres mg
				WHERE mg.genreId IN(
					SELECT g.genreId
					FROM Genres g
					WHERE g.name = 'Comedy')
				)
			)
		)
	)







	SELECT s.venueId
	FROM Screenings s INNER JOIN Movies_Screenings ms ON s.screeningId=ms.screeningId
			INNER JOIN Moives m ON ms.movieId=m.movieId
			INNER JOIN Moives_Genres ON m.movieId=




















----------------b------------------

SELECT COUNT(st.soldTicketsId)
FROM Sold_Tickets st INNER JOIN Screenings s ON st.screeningId=s.screeningId
			INNER JOIN Venues v ON s.venueId=v.venueId
			INNER JOIN Movies_Screening ms ON s.screeningId=ms.screeningId
			INNER JOIN Movies m ON ms.movieId=m.movieId
			INNER JOIN Movies_Actors ma ON m.movieId=ma.movieId
			INNER JOIN Actors a ON a.actorId=ma.actorId
WHERE v.name='Piata Unirii' AND a.name='Alain Delon'