Welcome to the Treehouse Community
Looking to learn something new?
Using Length Function
In the library database there's a books table with the columns id, title, author, genre and first_published.
Find the book with the longest title. Show the title and then the length. Alias the result of the length calculation to be longest_length. Only retrieve the longest book.
I'm sure im missing something simple. This is what i came up with.
SELECT title, LENGTH(title) AS "longest_length FROM books ORDER BY length DESC LIMIT 1;
2 things here.
1) You have "longest_length. Looks like a typo where you can lose the ".
2) You did not designate your ORDER BY correctly. You have to tell SQL what you want the LENGTH of. (There are actually 2 ways to do this. Declare LENGTH(column) OR reuse your alias)