Can you list the artist ids and their volume issues?
select t1.artist_id, t2.volume_issue from artist as t1 join volume as t2 on t1.artist_id = t2.artist_id
Which volumes have more than 2 weeks on top?
select * from artist as t1 join volume as t2 on t1.artist_id = t2.artist_id where t2.weeks_on_top > 2
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