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

Question

I've been struggling with this one for days.

Answer 1 · 2018-11-10T05:07:41Z

November 10, 2018 5:07am

Here is how I would do it:

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

Hope this does it for ya.

Answer 2 · 2018-11-11T04:05:35Z

November 11, 2018 4:05am

here is the correct answer for this challenge:

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

good luck :)

2 Answers