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

Posted by Jason Jorden
Jason Jorden
1,917 Points

I want to concatenate street, city, state, zip and country as Street, City, State ZIp. Country alias it to "address"

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

1 Answer

KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,971 Points
KRIS NIKOLAISEN
KRIS NIKOLAISEN
54,971 Points

The format specified in the challenge is:

Street, City, State Zip. Country

Some hints:

  • Double check your commas and spaces. You are missing a comma space between city and state.
  • There shouldn't be a comma between state and zip
  • Rather than concatenate a comma then a space you combine them. ", "
  • You haven't specified the table you are selecting your records from