Databases Reporting with SQL Working with Text Concatenating Text

Robert Hecht
Robert Hecht
6,702 Points

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

what is wrong with my code?

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 48,694 Points

Your alias should come after the field(s) being aliased

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