SELECT
  albums.name AS 'Album',
  albums.YEAR,
  artists.name AS 'Artist'
FROM
  albums
JOIN artists ON
  albums.artist_id = artists.id
WHERE
  albums.YEAR > 1980;