I am stuck on a Challenge
I am stuck on the Playlist Maker challenge in SQL lesson and cannot get past it no matter what I try.
I have a screen shot.
Thank you for any help!
Hi Nicolas Jennings,
can you please send a screenshot so that I can see what part of the challenge you are confused about? You can just edit the screenshot into the comment.
Hi. I have added two screen shots. its for two different challenges in the same lesson. Karaoke Song Selector won't let me advance and the second, Playlist Maker gives me a syntax error that I can't get past. Thank you for any help.
Hmm, that is weird. It appears to say there is a syntax issue under the command ). but in line 67 you never put that. And when I look at the other lines before and after that line it appears the same and there appears to be no problem. If you are still experiencing this problem, please send a support ticket for help from an administrator here.
I truly hope this helps and if you have any additional questions feel free to ask.
Thank you! At least I know I'm not crazy! :-)
My pleasure.
In case you haven't already resolved this issue, there are a couple errors in your code that are probably causing the error.
In the first screenshot, you have an extra ) after "Pop". The line should read:
SELECT name FROM artists WHERE genre = "Pop";
For the second screenshot, it looks like your solution to step 2 is actually incorrect, which is why you're being prevented from finishing the challenge. The second select statement should select all song titles where the mood is "epic" or where they were released after 1990.
I need help with this challenge. It is asking me to select just the titles and I am doing that and it will not let me proceed even though my line is asking the question posed in yellow. I do not understand why it won't let me proceed
Paul Smith It looks like the challenge is getting thrown off by line 29 in your code, which selects all properties and not just the titles. If you remove this line, I believe it should work correctly!
Please sign in to leave a comment.