Charles Fields4,205 Points
Has anyone been able to satisfy the question of querying to this format? Andrew Chalkley <firstname.lastname@example.org>
My answer is SELECT first_name || " " || last_name || " <" || email || ">" AS “to_field” FROM patrons; In the SQL Playground, using the similar table= customers, this yields the expected result: Lauren Chalkley Lauren.Chalkley@example.com Dave McFarland Dave.McFarland@example.com Pasan Premaratne email@example.com Andrew Chalkley Andrew@teamtreehouse.com
I can't help wondering if there's something about the question I don't get. Tried leaving out prefix space before email, adding a period on the end too.
The fancy/curly quotes around to_field are causing the task to fail. Either remove them or replace them with straight quotes and you should pass.