CREATE TABLE volume (Artist_ID VARCHAR2, Weeks_on_Top NUMBER)
CREATE TABLE artist (Famous_Title VARCHAR2, Artist_ID VARCHAR2)

What are the famous title of the artists associated with volumes with more 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
SELECT "T1"."Famous_Title" FROM "artist" "T1" JOIN "volume" "T2" ON "T1"."Artist_ID" = "T2"."Artist_ID" AND "T2"."Weeks_on_Top" > 2