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