Databases Reporting with SQL Working with Text Concatenating Text

Amy Hsieh
Amy Hsieh
6,023 Points

I can't see where the problem is. The system message: Your query needs didn't retireve the emails in the correct form

I have reviewed my query several times but still can't where I did wrong with the email format. Got blocked again by TREEHOUSE. Please help me.

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

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 47,480 Points

You have spaces around your <> symbols (and a period). Try:

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