Zachary keller3,178 Points
Cant understand the question, mainly the end part
"Generate a list of strings that are in the following format: Andrew Chalkley email@example.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 need to alias email as <email>? then alias all of it to be to_field?
my code so far
SELECT first_name || " " || last_name || " " || <email> AS to_field FROM patrons
it doesn't say the error now but that means the error is between AS to_field FROM patrons
KRIS NIKOLAISEN54,287 Points
The field name is email. It doesn't need to be aliased on it's own. However the format for the email field is that it should be enclosed in angle brackets. To do this the angle brackets should be inside quotes and concatenated as well in your SQL statement. Then the entire full name and formatted email is what should aliased as "to_field"
You're pretty close right now. Just need to put quotes around each angle bracket and concatenate.
Here Is the correct Answer
SELECT first_name || " " || last_name || " " || "<"|| email || ">" AS to_field FROM patrons