Databases Reporting with SQL Working with Text Concatenating Text

Stacy Villibord
Stacy Villibord
2,017 Points

Correct my syntax

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.

SELECT first_name || ' ' || last_name || ' ' || email FROM patrons AS "to_field";

1 Answer

Steven Parker
Steven Parker
203,989 Points

I see two issues at first glance:

  • the alias must immediately follow the concatenated field (before the FROM clause)
  • the email address needs to be surrounded in <> characters (as part of the concatenated literals)