Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialAlexandra Washick
6,545 PointsWHERE clause and ORDER BY?
This first question has me completely stumped. We're being asked to write a query to select all columns from the book table and display only the first five books in the fantasy genre, ordered by the oldest publication date. Here is what I have as my query:
SELECT * FROM books WHERE genre = "Fantasy" ORDER BY first_published ASC LIMIT 5;
This apparently isn't correct but from everything I'm finding online to help me figure this out, it should be? What am I missing?
2 Answers
Travis Alstrand
Treehouse Project ReviewerSame as Stephen Hood said, I copied what you've posted here exactly and pasted it into the first challenge and it worked great for me. Maybe refresh and try again, make sure it's exactly what you wrote here in your post. SQL is very particular and our Code Challenges are even more particular with what they want! 😃
Great job figuring out the query!
Alexandra Washick
6,545 PointsWell, I'm likewise not sure what fixed the issue, but like others said, today I copy and pasted the code I wrote here into the challenge and it finally accepted it! Not sure why it wouldn't do it the other day, but this was a good confidence boost to know I had it right all along!
Travis Alstrand
Treehouse Project ReviewerYes, that's very strange indeed, but I'm just glad it worked for you this time. Fantastic job here Alexandra Washick !! 👏
Stephen Hood
692 PointsStephen Hood
692 PointsHi Alexandra - I don't know if Treehouse "fixed" whatever was causing your issue, but I pasted that SQL into the challenge and it worked fine. Is it still not working for you?