Finding data using SQL
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.
my answer: SELECT title FROM books WHERE "Length" = "longest_length" DESC LIMIT 1;
I am getting this question wrong could someone please help me by explaining what I am doing wrong
Daniel L.3,837 Points
There are a couple different ways of doing this, at least to my knowledge, there might be more.
SELECT title, LENGTH(title) AS longest_length FROM books ORDER BY longest_length LIMIT 1;
SELECT title, MAX(LENGTH(title)) AS longest_length FROM books;