Write a query to join artist and album on the common property artist_id. Notice that 3, Bill Evans won't appear in the results.

Make sure to pick INNER JOIN album followed by ON artist.artist_id and then =, album.artist_id.