What does this query do?
name
title
id
artist_id
artist
It selects the artist name and album title of rows where the id matches the artist_id.