What should be the code for this one? I have entered SELECT * FROM books ORDER BY first_published DSC;

Question

But it is still giving me a syntax error.

Answer 1 · 2019-08-26T10:56:19Z

August 26, 2019 10:56am

I’m assuming you’re looking at Task 2? If so, you almost had it. The keyword to sort descending is DESC.

Task 1: SELECT * FROM phone_book ORDER BY last_name, first_name

Task 2: SELECT * FROM books ORDER BY first_published DESC

Task 3: SELECT * FROM books ORDER BY genre, title

1 Answer