Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Databases

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,623 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

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.