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
Wiley Conte
9,618 PointsLooks like I've got this address formatted correctly.
What am I missing:
''' SELECT street || ", " || city || ", " || state || " " || zip || ". " || country AS "address" FROM addresses; ''''
3 Answers
Wiley Conte
9,618 PointsThe question asks to concatenate the addresses into the readable format "Street, city, state zip. Country"
Žiga Pregelj
18,126 Pointsmaybe this will help you:
https://teamtreehouse.com/community/reporting-with-sql-challenge-task-1-out-of-2
Also, nex time be sure to post question with provided example/task, you can do it directly from the questin page (get help), so we can help you better and more efficient.
Wiley Conte
9,618 PointsI am having the issue with task 2/2 in the reporting with sql challenges regarding concatenation. Is there a link to questions on this task?
Žiga Pregelj
18,126 PointsThis will work for you:
SELECT street || ", " || city || ", " || state || " " || zip || ". " || country AS address FROM addresses;
You need to put address, without "" ;)
Žiga Pregelj
18,126 PointsŽiga Pregelj
18,126 PointsWhat do you want to do ? Why are you putting || after every value ?