what should be the code for challenge 1 for finding the length of TEXT, I have tried different methods
first of all I have put SELECT title, LENGTH (title) AS "longest_title" FROM books ORDE BY DECS; However it is keep giving me an error. Can you please help me?
KRIS NIKOLAISEN53,479 Points
- the alias for longest title is "longest_length"
- You can order by this alias: ORDER BY longest_length DESC
- You will need to limit your results to one record