Caleb Newell5,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 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 don't really understand what it is asking me. can someone refrase it for me?
Steven Parker195,447 Points
Let's say you had a user record that included this data:
The challenge would want to see this Andrew Chalkley <firstname.lastname@example.org>
as a single field with the name alias of "to_field".
Does that make more sense?