Databases Reporting with SQL Working with Text Concatenating Text

Caleb Newell
Caleb Newell
5,077 Points

Help with this SQL query

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.

-i don't really understand what it is asking me. can someone refrase it for me?

1 Answer

Steven Parker
Steven Parker
195,447 Points

Let's say you had a user record that included this data:
  first_name :point_right: Andrew
  last_name :point_right: Chalkley
  email :point_right: andrew‍@teamtreehouse.com

The challenge would want to see this :point_right: Andrew Chalkley <andrew‍@teamtreehouse.com>
as a single field with the name alias of "to_field".

Does that make more sense?

Caleb Newell
Caleb Newell
5,077 Points

just one more thing, I have written the code SELECT first_name || " " || last_name || " " || "<" || email || ">" AS "to_field" FROM customers; and it sais that there is something wrong with my code. I don't see anything, is there something small I'm missing?

Steven Parker
Steven Parker
195,447 Points

The challenge instructions say "In the library database there's a patrons table ...",
but this query is trying to select FROM customers. :see_no_evil: