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 Reporting with SQL Ordering, Limiting and Paging Results Ordering Results

Posted by James Silvester
James Silvester
4,511 Points

Why doesn't this work?

SELECT * FROM books ORDER BY Genre, BY Title;

2 Answers

Caleb Kemp
Caleb Kemp
12,754 Points
Caleb Kemp
Caleb Kemp
12,754 Points

There are two problems

  1. In the challenge, Genre and Title are not supposed to be capitalized
  2. In front of the "title" category, an extra word "BY" was added

So, the final format should look like this

SELECT * FROM books ORDER BY category_one, category_two;

I hope that helps :smile:

James Silvester
James Silvester
4,511 Points

cheers

James Silvester
James Silvester
4,511 Points
James Silvester
James Silvester
4,511 Points

answer: SELECT * FROM books ORDER BY genre, title;