Databases Reporting with SQL Working with Text Changing Cases of Strings

Christopher Parke
Christopher Parke
21,977 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
28,838 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
177,931 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,977 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
177,931 Points

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