Which is the right table in this query?
artist
, since it's the one we join
album
since it's the one we select
artist
, since it's the one we join.