This community-built FAQ covers the “Select” exercise from the lesson “Queries”.
Paths and Courses
This exercise can be found in the following Codecademy content:
Web Development Data Science
Learn SQL
FAQs on the exercise Select
Join the Discussion. Help a fellow learner on their journey.
Ask or answer a question about this exercise by clicking reply ( ) below!
Agree with a comment or answer? Like ( ) to up-vote the contribution!
Need broader help or resources ? Head here .
Looking for motivation to keep learning? Join our wider discussions .
Learn more about how to use this guide.
Found a bug ? Report it!
Have a question about your account or billing? Reach out to our customer support team !
None of the above? Find out where to ask other questions here !
Why is my mention of year in my code in blue? is year a key word/function in SQL? Or is it a bug?
My code was exactly as described in the " Hint" section, but is given incorrect.
7 Likes
Same here. I can copy-paste the code and it doesn’t work.
There is definitely a bug here, unable to query year.
I believe we should edit the first instruction and add year to it, instead of givind a new instruction leaving the first one there…
1 Like
I had the same issue…“year” was in blue and would not run without an error, even when I copy & pasted the answer in. I did the tip where I just amended my original line to include “year” instead of typing an entirely new query and that worked for me.
toddyh
January 15, 2022, 2:21pm
#8
Apparently “YEAR” is a reserved keyword.
I’m guessing it’s something to do with that but not really sure.