Databases Reporting with SQL Working with Text Concatenating Text

How do I concatenate into this exact format - Andrew Chalkley <andrew@teamtreehouse.com>?

I've been struggling with this one for days.

2 Answers

Tareq Alothman
Tareq Alothman
17,921 Points

Here is how I would do it:

select concat(firstname, ' ', lastname, '<', tolower(firstname), '@teamtreehouse.com>')

Hope this does it for ya.

Tareq Alothman
Tareq Alothman
17,921 Points

here is the correct answer for this challenge:

SELECT FIRST_NAME || ' ' || LAST_NAME || ' <' || EMAIL || '>' AS "to_field" FROM PATRONS

good luck :)