SELECT
    tracks.Name, albums.Title, artists.name
FROM
    tracks
    INNER JOIN albums ON tracks.AlbumId=albums.AlbumId
    INNER JOIN artists ON albums.ArtistId=artists.ArtistId
WHERE
    artists.ArtistId>270