title: Create a list of album titles and the unit prices for the artist "Audioslave" from given ER diagram in SQLite
body: <p>Given the ER diagram can someone please provide me with the code for SQLite to find the query as asked in the question.<a href="https://i.stack.imgur.com/nCWRG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nCWRG.png" alt="enter image description here"></a></p>
  
  <p>I'm using Chinook Database</p>
  
  <p>EDITED - Below is the code I'm attaching which I used to get the query, but unfortunately, the answer which I'm getting is wrong</p>
  
  <pre><code>SELECT a.Title, t.UnitPrice
  FROM Albums a, Tracks t
  WHERE t.AlbumId IN
        (SELECT a.AlbumId
         FROM Albums a
         WHERE a.ArtistID IN
               (SELECT ar.ArtistID
                FROM Artists ar
                WHERE ar.Name = 'Audioslave'))
  </code></pre>