KRIS NIKOLAISENPro Student 44,108 Points
Here you are concatenating first_name and last_name and email with some formatting. The alias for this column will be 'to_field'. For the formatting there is a space between first and last name. Email is surrounded by <>. Use the concatenation operator || to create this field.
To create a space
SELECT C1 || ' ' || C2 FROM table
To format email
SELECT ' <' || email || '>' FROM table
To alias as 'to_field'
SELECT C1 || C2 || C3 AS 'to_field' FROM table