Databases Reporting with SQL Working with Text Concatenating Text

Grafton John
Grafton John
1,669 Points

Concatenation code challange

I wrote this code to produce Andrew Chalkley andrew@teamtreehouse.com.

SELECT first_name ||' '|| last_name || ' <'|| LOWER(first_name)|| '@teamtreehouse.com>.' AS "to_field" FROM patrons;

And the code is being flagged as being incorrect. Can anyone tell me what I am missing?

2 Answers

Adam Pengh
Adam Pengh
28,838 Points

You need to use the email column from the database. I used the below and it worked.

SELECT first_name || " " || last_name || " <" || email || ">" AS 'to_field'
FROM patrons
Grafton John
Grafton John
1,669 Points

Adam thank you very much for your assistance. Have wonderful New Year and thank you again.