REPORTING W/SQL Challenge Task 2 of 2

Thanks guys!! I figured it out just after I posted. I should have saved the code and posted here for the next person who gets stuck. I just remember that it was picky, picky, picky about where the spaces, commas, and || were placed. Good practice though and good to discover that there IS an answer; the question is not flawed.

You're almost there, seems like a problem somewhere in your string concatenation.

The example is there as a guide for you.

Try this

 SELECT street AS "Street" || " " || city AS "City" || "," || " " || state AS "State" || "," || " " || zip as "Zip" || "." " " || country as "Country" AS address FROM addresses; 

miss out the first comma in your string concatenation and try that :-)

From what I can tell, you're miss a || toward the end, between zip as "Zip" and country as "Country"

SELECT street AS "Street" || "," || " " || city AS "City" || "," || " " || state AS "State" || "," || " " || zip as "Zip" || "." [RIGHT HERE] " " || country as "Country" AS address FROM addresses;

Hope this helps.