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

Development Tools

Kam Mitchell
Kam Mitchell
14,073 Points
Posted by Kam Mitchell
Kam Mitchell
14,073 Points

What am I doing wrong here? Error in "Ordering the Result Set"

**EDIT: I now know this is a known issue the staff is working on these code challenges. Thanks **

Challenge Task 1 of 2

Order "actors" by "name" in reversed alphabetical order.

Type in your command below, then press Enter.

SELECT * FROM actors ORDER BY name DESC;

When I press enter, I get this bummer message: Bummer! The actors are in the wrong order. Try using a keyword to descend the results.

However, the table shows up, and the actors ARE in the correct order. The descend keyword is in the message I typed...

I've tried

SELECT name FROM actors ORDER BY name DESC;

and

SELECT actors.name FROM actors ORDER BY name DESC;

none of them work...

Is this challenge bugged? Or am I missing something obvious?

Kam Mitchell
Kam Mitchell
14,073 Points
Kam Mitchell
Kam Mitchell
14,073 Points

Stephen Printup Thanks! Found a few other posts with similar issues, too. I appreciate the link.

2 Answers

Petar Popovic
PLUS
Petar Popovic
Courses Plus Student 23,421 Points
Petar Popovic
Petar Popovic
Courses Plus Student 23,421 Points

Actually you are missing something :) Task asks you to order actors by name descending, not to order names of actors like you tried to do.

Correct answer is 

SELECT * FROM actors ORDER BY name DESC;
Ary de Oliveira
Ary de Oliveira
28,298 Points
Ary de Oliveira
Ary de Oliveira
28,298 Points

Database Foundations

Challenge Task 1 of 2

Order "actors" by "name" in reversed alphabetical order.

SELECT * FROM actors ORDER BY name DESC;

Challenge Task 2 of 2

Order "movies" with the release "year" ascending with the "title" in alphabetical order. Type in your command below, then press Enter.

SELECT * FROM movies ORDER BY year ASC, title ASC;