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

Rohit Gopalan
Rohit Gopalan
77,303 Points

Issue with answering code challenge of length of title in SQL

Whenever I try to enter queries for this code challenge, there are always communication errors being reported. Is there any reason why this is happening and how to overcome this issue?

3 Answers

Martin Sole
Martin Sole
71,054 Points

Hi Andrew, I seem to be having the same issue with the loss of connection for this challenge, I'm using the below query. I have tried this within the workspace using the customer table and username column and it worked fine.

SELECT title, LENGTH(title) as longest_length FROM books ORDER BY longest_length DESC LIMIT 1;

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher

Apologies, the challenge should work now :)

SELECT title, MAX(LENGTH(title)) AS longest_length FROM books;

from this forum thread;

https://teamtreehouse.com/community/problems-with-sql-challenge