7/7 is syntax error


#1

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;

then,

error is happened.

Error: near line 10: near "as": syntax error

Please tell me the correct code.


#2

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;