In the library database there's a patrons table listing all the users of the library. The columns are id, first_name, la
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 firstname.lastname@example.org. 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.
Steven Parker172,046 Points
Since you didn't ask a question, I'm guessing you'd like some generic hints:
- use the concatenation operator ("|") to combine strings together
- remember to include spaces between words using string literals
- also include the angles ("<" and ">") on either side of the "email" field
- don't forget the alias name ("to_field")