I'm on Challenge Task 1 of 2 on Reporting with SQL. Why won't it pass?

Question

We are to concat the first name, last name and email address in this format:

and report it as "to_field"

Here is my code:

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

When I put it in the SQL Playground using the customers table like this:

SELECT first_name || ' ' || last_name || '  <'|| email || '>' AS "to_field"
FROM customers
ORDER BY last_name
LIMIT 1;

It returns "Andrew Chalkley Andrew@teamtreehouse.com" in a column labeled "to_field".

Seems right no? Am I missing something?

Answer 1 · 2021-04-10T00:00:19Z

April 10, 2021 12:00am

It looks like you have an extra space in the ' <' element which is throwing of the formatting. Other than that it should be correct.

Welcome to the Treehouse Community