Databases Reporting with SQL Working with Text Concatenating Text

In the library database there's a patrons table listing all the users of the library. The columns are id, first_name,

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.

Been stuck on this one.

My answer was

SELECT first_name || " " || last_name || email AS "to_field" FROM patrons;

2 Answers

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 45,225 Points

The email column does not include <> in the formatting. You have to add that yourself.

Thank you!

Joni Whitworth
Joni Whitworth
1,425 Points

I made the same mistake! It's hard to remember that.