SQL Error: no such column: first_name [RESOLVED]

Why isn't this a valid column name?

Link to challenge: https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text

Challenge Task 1 of 2

In the library database there's a patrons table listing all the users of the library.

The columns are id, first_name, last_name, address, email, library_id and zip_code.

Generate a list of strings that are in the following format: Andrew Chalkley andrew@teamtreehouse.com. Concatenate the first name, last name and email address for all users.

Alias it to to_field. This will be used in the "To" field in email marketing

Figured it out.

It WAS a valid column name as long as you use 'FROM patrons'

so it knows which table the SELECT statement is referring to:

SELECT first_name || ' '  || last_name || ' <' || email || '>' AS to_field FROM patrons;

Now I'm having trouble with the second part of the challenge:

Challenge Task 2 of 2

In an eCommerce database there's a customers table.

There is an id, nickname, street, city, state, zip, country and user_id columns.

Concatenate the street, city, state, zip and country in the following format. Street, City, State Zip. Country e.g. 34 NE 12 st, Portland, OR 97129. USA. Alias the concatenated string as address

The SQL I tried was:

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

It gives me an error:

SQL Error: no such column: street 

So this seems to be a different issue than the first part of the challenge

because I am using 'FROM customers' at the end of the query

but maybe that FROM part is getting cutoff somehow?