How do I correctly format the email?
The challenge is to generate a list of patrons with the first name , last name and email concatenated. Format email to firstname.lastname@example.org how is this done?
Steven Parker159,129 Points
You'll notice that in the format sample shown in the instructions, there are some spaces and symbols. You'll need to include some literal strings with your columns as you construct the SELECT clause.
SELECT /*other bits...*/ || ' <' || email || '>' /*...alias and other clauses*/
Like this? SELECT last_name || " " || first_name ||' <' || email || '>' AS "to _field" From patrons;