I am not getting the correct output


#1

5.Combine the albums and artists table using a LEFT OUTER JOIN. Let albums be the left table.

SELECT * FROM albums
LEFT OUTER JOIN artists
ON albums.id = tracks.id;

6.Combine the albums and artists table using a LEFT OUTER JOIN. Let artists be the left table.

SELECT * FROM artists
LEFT OUTER JOIN albums
ON tracks.id = albums.id;


#2

@pkdevesh,
Could you provide us the link this course section ??

But what seems strange
that you point to the albums table and the artists table
and then you compare albums-id against tracks-id