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![](https://ecs-static.teamtreehouse.com/assets/views/marketing/shared/community-banner-white-47072046c51352fe6a69f5e691ff5700b28bb11d45197d7bdf066d9ea3f72d0c.webp)
![Anjali Paida](https://secure.gravatar.com/avatar/6a1d3e2a9c5ab5083f627e2cf5701f37?s=96&d=https%3A%2F%2Fecs-static.teamtreehouse.com%2Fassets%2Fcontent%2Fdefault_avatar-445fbbabfc8dc9188fb5967fe43322ee0c3e0dd1e10f378bf8343784af5a13eb.webp&r=pg)
Anjali Paida
533 PointsOrder "movies" with the release "year" ascending with the "title" in alphabetical order.
where am doing wrong here ::: . my answer is : SELECT * FROM movies ORDER BY title ASC, year ASC;
but its still showing error :(
3 Answers
![Steven Parker](https://uploads.teamtreehouse.com/production/profile-photos/969492/micro_tool_chess_set_2.jpg)
Steven Parker
230,688 Points
It looks like you have your ordering criteria reversed:
SELECT * FROM movies ORDER BY year ASC, title ASC;
Since ascending is the default, you can probably also shorten the query like this:
SELECT * FROM movies ORDER BY year, title;
![A X](https://uploads.teamtreehouse.com/production/profile-photos/1279642/micro_rojo5.jpg)
A X
12,842 PointsAnajali, it's tough to assist with SQL based questions without knowing what database is and what code challenge you're trying to create your query from unless it's an obvious syntax error.
I suspect you're referencing the same query these people have here, you can reference any of these for more information: https://teamtreehouse.com/community/order-movies-with-the-release-year-ascending-with-the-title-in-alphabetical-order-challenge-task-2-of-2-error
![jessb](https://secure.gravatar.com/avatar/ddf4d04fb3000a128d1869ae299f4cd5?s=96&d=https%3A%2F%2Fecs-static.teamtreehouse.com%2Fassets%2Fcontent%2Fdefault_avatar-445fbbabfc8dc9188fb5967fe43322ee0c3e0dd1e10f378bf8343784af5a13eb.webp&r=pg)
jessb
3,551 PointsThank you Steven, that was the correct answer. I wrote the same code as Anjali did.