Databases Reporting with SQL Working with Text Concatenating Text

Siraj Khan
Siraj Khan
3,451 Points

Whats wrong with my code in this challenge.?

Whats wrong with my code in this challenge.?

Frosty Lee
Frosty Lee
2,787 Points

Happy to help but we cannot see your query. Please add it here and we can advise.

Siraj Khan
Siraj Khan
3,451 Points

SELECT first_name || " " || last_name || " <" || email || ">." FROM patrons;

Siraj Khan
Siraj Khan
3,451 Points

SELECT first_name || " " || last_name || " <" || email || ">." FROM patrons;

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 42,368 Points

You are missing the alias and don't need the period at the end of the email:

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

Otherwise good job