Databases Reporting with SQL Working with Text Concatenating Text

jamie rose
jamie rose
3,637 Points

What am i doing wrong?

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 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.

jamie rose
jamie rose
3,637 Points

select first_name || ' ' ||last_name || ' <' || email || '>.' as "to_field" from patrons

jamie rose
jamie rose
3,637 Points

please ignore, found what i was doing wrong.