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.
Ralph Findling
5,270 PointsExpected 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
Treehouse Moderator 145,623 PointsHey 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.
Ralph Findling
5,270 PointsRalph Findling
5,270 Pointshttps://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.