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 trial
Pedro Baumann
12,815 PointsDatabase Foundations Reading Data from Databases with SQL Ordering the Result Set [Solved]
On the second challenge task I don't seem to be able to answer correctly, I have tried all the variants just in case I missunderstood the question.
"Order "movies" with the release "year" ascending with the "title" in alphabetical order."
SELECT year, title FROM movies ORDER BY year ASC, title ASC ;
I have done this in all the posible variants (without the ask, cnangin the select order of the items, DESC one or the thwo items in all orders). Still I always get the same mistake: " Bummer! Your query is not ordering 'movies' by release 'year' and then by 'title'."
But the results show me it is!!
Any hints would be appreciated
Pedro Baumann
12,815 PointsThanks Carlson, I was pretty sure I had tried that first, but it seemed not! Thanks a lot! I was in one of those "bang my head against the screen till it works" moment.
Carson Yong
13,279 PointsCarson Yong
13,279 PointsSelect everything instead of just year and title...
SELECT * FROM movies ORDER BY year ASC, title ASC;