CREATE TABLE music_festival (id NUMBER, music_festival CLOB, date_of_ceremony CLOB, category CLOB, volume NUMBER, result CLOB)
CREATE TABLE artist (artist_id NUMBER, artist CLOB, age NUMBER, famous_title CLOB, famous_release_date CLOB)
CREATE TABLE volume (volume_id NUMBER, volume_issue CLOB, issue_date CLOB, weeks_on_top NUMBER, song CLOB, artist_id NUMBER)

Show the famous titles of the artists with both volumes that lasted more than 2 weeks on top and volumes that lasted less than 2 weeks on top.
SELECT T1.famous_title FROM artist AS T1 JOIN volume AS T2 ON T1.artist_id = T2.artist_id WHERE T2.weeks_on_top > 2 INTERSECT SELECT T1.famous_title FROM artist AS T1 JOIN volume AS T2 ON T1.artist_id = T2.artist_id WHERE T2.weeks_on_top < 2
SELECT "T1"."famous_title" FROM "artist" "T1" JOIN "volume" "T2" ON "T1"."artist_id" = "T2"."artist_id" AND "T2"."weeks_on_top" > 2 INTERSECT SELECT "T1"."famous_title" FROM "artist" "T1" JOIN "volume" "T2" ON "T1"."artist_id" = "T2"."artist_id" AND "T2"."weeks_on_top" < 2