I'm stuck at "Querying Tables 7/7".
My code is below.
select * from albums inner join tracks on albums.id as Albums = tracks.id;
error is happened.
Error: near line 10: near "as": syntax error
Please tell me the correct code.
Renaming the column should be put forward.
Here's my code:select albums.id as 'album_id', albums.name, albums.artist_id, albums.year from albums join tracks on albums.id=tracks.album_id;