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

Databases

Order "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
Steven Parker
229,788 Points

:point_right: 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;

Anajali, 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

https://teamtreehouse.com/community/where-am-i-wrong-here-2

https://teamtreehouse.com/community/database-foundations-reading-data-from-databases-with-sql-ordering-the-result-set

jessb
jessb
3,551 Points

Thank you Steven, that was the correct answer. I wrote the same code as Anjali did.