Databases Reporting with SQL Working with Text Concatenating Text

Pasha Stegall
Pasha Stegall
Front End Web Development Techdegree Student 1,221 Points

Challenge Task 1 of 2 - Can't get beyond it, What have I done wrong??

It keeps saying your query didn't display the email correctly.

SELECT first_name || " " || last_name AS "Full Name", email AS "to_field" FROM patrons ORDER BY last_name ASC ;

2 Answers

Hi Pasha -

You are very close. You are trying to format the text to look like this:

Andrew Chalkley <>

In order to do so, we need to concatenate the < and > as well. See the code below:

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

Hope this helps!