Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Reporting with SQL Working with Text Changing Cases of Strings

Christopher Parke
Christopher Parke
21,978 Points
Posted by Christopher Parke
Christopher Parke
21,978 Points

No error, but error?

Nice job with the error testing chalkers. I have the output exactly correct -- verbatim yet I can't pass the task. Let's get a slow clap going here. Error message below.

"Andrew CHALKLEY", "MCL1001" not "Andrew CHALKLEY", "MCL1001".

3 Answers

Adam Pengh
Adam Pengh
29,881 Points
Adam Pengh
Adam Pengh
29,881 Points

Part 1:

SELECT 
  LOWER(title) AS lowercase_title, 
  UPPER(author) AS uppercase_author
FROM books

Part 2:

SELECT 
  first_name || ' ' || UPPER(last_name) AS full_name,
  library_id
FROM patrons
Steven Parker
Steven Parker
231,268 Points
Steven Parker
Steven Parker
231,268 Points

You forgot to show your query code to allow us to make an accurate diagnosis.

But often, when the error message indicates that your output looks like what is expected, the problem might not be in the data but in the column names. Check for a possible misspelling of the alias names assigned to the columns.

Christopher Parke
Christopher Parke
21,978 Points
Christopher Parke
Christopher Parke
21,978 Points

It seems that checkbox is currently not functioning because this is the second time I've opened a ticket where it didn't include the code.

Steven Parker
Steven Parker
231,268 Points
Steven Parker
Steven Parker
231,268 Points

Anytime that happens, just type it into the question, or add it using a comment.