No, you have to think of organizing your SQL in the three main sections (I'm generalizing here)
The SELECT portion contains the output columns you would like. So in the text of the problem it states that it wants you to select the albums and tracks table and to specifically use an alias for the album_id column. That should all be in the top SELECT portion. You should think about explicitly listing your columns and avoid using the *.
What I mean is write this:
SELECT id, name
The reason why is that when you join two tables you are dealing with one or more columns that are the same. If you write the '*' you are stating the common fields twice.
The FROM you wrote looks like it might not be correct. I believe these are the tables you are working with:
I find it always best to think of what it is that makes one table reference another.
So in this particular exercise you need to join the TRACKS table with the ALBUMS table. Looking at the TRACKS table I see that there is a field called album_id. The ALBUMS table has a field called id. Those are the two fields that mean the same thing. In your code you tried joining the tracks.id = albums.id, which are not the same thing. So if you were to imagine drawing a line between the TRACKS and ALBUMS tables make sure to draw a line between the two fields that are the same thing.
What you need to do is join the two tables with:
tracks.album_id = albums.id
In this particular case you are not being asked to filter or meet certain conditions so there is no need for the WHERE clause.
I will leave you try to correct this on your own. Message back in here if you run into further issues or need more feedback. I'll happily help.