
Tom Holliday
2,868 PointsI don't understand how we are supposed to know what the correct email formatting is. Are we supposed to add the < signs?
I've tried so many combinations but none of them work e.g. SELECT first_name || " " || last_name || " " || email AS "to_feild" FROM patrons; SELECT first_name || " " || last_name || " <" || email || ">" AS "to_feild" FROM patrons; SELECT first_name || last_name || email AS "to_feild" FROM patrons; SELECT first_name || " " || last_name || " <" || email || ">."AS "to_feild" FROM patrons;
I tried more than that but you get the idea.
1 Answer

Steven Parker
205,566 PointsYou're right about needing the angle symbols. And your 2nd try would have passed except for spelling the alias as "to_feild" instead of "to_field".
Fix that and you've got it.
Tom Holliday
2,868 PointsTom Holliday
2,868 Pointsbruh I'm too smart, Thanks.