Databases Reporting with SQL Working with Text Concatenating Text

I'm not seeing the difference?

Your query didn't retireve the addresses in the correct format. Expecting 2532 2nd ST, San Diego, California 90222. USA not 2532 2nd ST, San Diego, California 90222. USA.

SELECT street || ', ' || city || ', ' || state || ' ' || zip || '.' || ' USA' AS address FROM addresses;

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 44,108 Points

From the instructions:

In an ecommerce database there's a addresses table. There is an id, nickname, street, city, state, zip, country and user_id columns.

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 44,108 Points

There is a country column that you need to select

SELECT street || ', ' || city || ', ' || state || ' ' || zip || '. ' || country AS address FROM addresses;

No there is no country column.