Databases Reporting with SQL Working with Text Getting the Length of a String

Erin Clayton
Erin Clayton
3,840 Points

What am I doing wrong?

SELECT title, length(title) AS longest_length ORDER BY longest_length DESC FROM books limit 1;

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 43,264 Points

Just a little out of order:

SELECT title, length(title) AS longest_length FROM books ORDER BY longest_length DESC limit 1;

Chris Jones
Chris Jones
Java Web Development Techdegree Graduate 23,902 Points

Hi Erin,

You did well and have the answer, but you have the SQL syntax out of order. The FROM clause comes immediately after the SELECT clause, not after the ORDER BY clause. Moving the FROM clause to it's correct position gives us:

SELECT title, length(title) AS longest_length FROM books ORDER BY longest_length DESC limit 1;

Good job, though! It's a minor mistake!