CREATE TABLE Album (Title VARCHAR2, AlbumId VARCHAR2)
CREATE TABLE Genre (GenreID VARCHAR2, Name VARCHAR2)
CREATE TABLE Track (AlbumId VARCHAR2, GenreID VARCHAR2)

What are the album titles for albums containing both 'Reggae' and 'Rock' genre tracks?
SELECT T1.Title FROM Album AS T1 JOIN Track AS T2 ON T1.AlbumId = T2.AlbumId JOIN Genre AS T3 ON T2.GenreID = T3.GenreID WHERE T3.Name = 'Reggae' INTERSECT SELECT T1.Title FROM Album AS T1 JOIN Track AS T2 ON T1.AlbumId = T2.AlbumId JOIN Genre AS T3 ON T2.GenreID = T3.GenreID WHERE T3.Name = 'Rock'
SELECT "T1"."Title" FROM "Album" "T1" JOIN "Track" "T2" ON "T1"."AlbumId" = "T2"."AlbumId" JOIN "Genre" "T3" ON "T2"."GenreID" = "T3"."GenreID" AND "T3"."Name" = 'Reggae' INTERSECT SELECT "T1"."Title" FROM "Album" "T1" JOIN "Track" "T2" ON "T1"."AlbumId" = "T2"."AlbumId" JOIN "Genre" "T3" ON "T2"."GenreID" = "T3"."GenreID" AND "T3"."Name" = 'Rock'