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 Querying Relational Databases Set Operations Set Operations

Posted by Alexei Lazarowicz
Alexei Lazarowicz
5,153 Points

I have no idea how to sort the names by what letter they start with

I had code earlier but when I tried to go back to edit the post it deleted it

1 Answer

Steven Parker
Steven Parker
231,265 Points
Steven Parker
Steven Parker
231,265 Points

The challenge isn't asking you to sort anything, just filter the list (as typically done with a WHERE clause).

You can make use of the way that inequality operators ( < and > ) work on words by comparing alphabetic order. For example, if you filtered a query using ... WHERE word < "D" the result set would only contain words that begin with "A", "B", and "C".