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.?

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 47,300 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