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 trialChristopher Parke
21,978 PointsNo 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
29,881 PointsPart 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
231,184 PointsYou 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
21,978 PointsIt 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
231,184 PointsAnytime that happens, just type it into the question, or add it using a comment.