Am new here and i want to learn. But the code in the code editor returns error. "create a table with appropriate name". I cant get pass 3


#1

Below this line, add a link to the EXACT exercise that you are stuck at.



Replace this line with your code.


#2

can you please post your code here?
also include the link that goes to the lesson.


#3

SELECT
albums.name AS 'Album'
albums.year,
artists.name AS 'Artist'
FROM
albums
JOIN artists ON
albums.artist_id = artists.id
WHERE
albums.year > 1980;
This code is not working
Error message: Error near line line1. albums


#4

albums.name AS 'Album'

add a , after it

and here

albums.artist_id = artists.id

add a ; after it

If problem persists, post update version of your code and include the lesson link please


#5

Codeislife.Thanks guys. it works​:+1::+1:


#6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.