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

Ralph Findling
Ralph Findling
5,270 Points
Posted by Ralph Findling
Ralph Findling
5,270 Points

Expected and returned output is identical, why does the challenge not pass?

SELECT street || ", " || city || ", " || state || " " || zip || ". " || country FROM addresses;

I was told: 2532 2nd ST, San Diego, California 90222. USA is not the same as: 2532 2nd ST, San Diego, California 90222. USA

Is there a problem with the checking?

1 Answer

Jason Anders
MOD
Jason Anders
Treehouse Moderator 145,860 Points
Jason Anders
Jason Anders
Treehouse Moderator 145,860 Points

Hey Ralph.

Often with the challenges, they are very picky and very specific, so the problem could lie with spacing, capitalization, and/or punctuation.

If you could link to the actual quiz (In this case, just pasting the challenge's URL in a comment), we will be able to help you trouble shoot.

:dizzy:

Ralph Findling
Ralph Findling
5,270 Points
Ralph Findling
Ralph Findling
5,270 Points

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text

Thanks for the reply. I retraced my steps and realized that I didn't add the alias "address", it should be:

SELECT street || ", " || city || ", " || state || " " || zip || ". " || country AS address FROM addresses;

The error message was a bit confusing, since both strings were the same! Thanks for your help with this.