Databases Reporting with SQL Working with Text Creating Excerpts

Getting the following error message: Bummer: Expecting results like 'L Chalkley' not 'L Chalkley'. What is going on?

Title says it all. Am I getting the right result in the wrong way or what exactly?

2 Answers

Steven Parker
Steven Parker
195,074 Points

It sure looks like the right data, so the problem is most likely how it's organized. I'd bet the issue is either:

  • the wrong number of columns (2 are expected)
  • the wrong column names (they should be "initial" and "last_name")

If that's not it, post your complete query code so I can take a look and be more specific.

Ken Alger
Ken Alger
Treehouse Teacher

Need to see your code to determine the issue on this one.