Screen Link:
https://app.dataquest.io/c/81/m/464/intermediate-joins-in-sql/4/combining-multiple-joins-with-subqueries
My Code:
WITH
ta AS(SELECT
t.track_id,
ar.name artist_name
al.title album_title
FROM track t
INNER JOIN album al ON al.album_id = t.album_id
INNER JOIN artist ar ON ar.artist_id =al.artist_id)
SELECT ta.album ,ta.artist_name artist,COUNT(*) tracks_purchased
from invoice_line il join ta on ta.track_id=il.track_id
Group by 1 ,2
Order by 3 DESC
LIMIT 5;
What I expected to happen:
Answer should have come by this way also , Cannot understand the error
What actually happened:
Following error is coming
(sqlite3.OperationalError) near "al": syntax error
[SQL: WITH ta AS(SELECT t.track_id, ar.name artist_name al.title album_title FROM track t INNER JOIN album al ON al.album_id = t.album_id INNER JOIN artist ar ON ar.artist_id =al.artist_id) SELECT ta.album ,ta.artist_name artist,COUNT(*) tracks_purchased from invoice_line il join ta on ta.track_id=il.track_id Group by 1 ,2 Order by 3 DESC LIMIT 5;]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
Can’t understand what is wrong