I am having trouble with the following prompt:
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.
the query which I thought would work is as follows:
SELECT title, LENGTH(title) AS longest_length FROM books DESC LIMIT 1;
I have also tried putting quotations around "longest_length" which does not seem to help. While this may be a simple misunderstanding on my end, any advice for how to proceed would be much appreciated.
KRIS NIKOLAISENPro Student 46,011 Points
You haven't named a column to sort by. Try ORDER BY longest_length DESC to get the title with the longest length.