David Corrales4,275 Points
Confused need help properly adding brackets around an email!
Challenge Task 1 of 2 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.
Type in your command below, then press Ctrl-Enter.
Bummer: There's something wrong with your SQL statement. Please review your code and try again.
SELECT first_name || " " || last_name || " <" || email || "> " || AS to_field FROM patrons;
Steven Parker170,254 Points
You're really close! I see two issues left:
- there's an extra concatenation operator ("||") after the last string
- that last string also has an unneeded space at the end ("> ")