Join on the different-type columns artist.name and album.artist_id and notice that we get no results.
artist.name
album.artist_id
Make sure to pick . followed by name and then =, album, ., artist_id.
.
name
=
album
artist_id