Hmm, I want to know the famous titles 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
famous titles of the artists refers to Famous_Title; associated with refers to a JOIN operation between artist and volume tables; volumes with more than 2 weeks on top refers to Weeks_on_Top > 2;