Cosmin Iuga2,352 Points
I'm so lost here. :(
So lost here. Please help:
SELECT first_name ||" "|| last_name ||" "|| email AS "Full Name", to_field AS "To" FROM patrons;
Sean T. Unwin28,651 Points
In the previous lesson, right before this Challenge, there a quick note about using single vs double quotes. You need to understand when to use which. The key is to use single quotes for String literals, whereas double quotes are used for identifiers (I've found this is optional in many cases, at least with MS SQL Server and MySQL).
There is no reason to alias
Full Name. Don't alias this field at all, actually.
The resulting String concatenation is to be aliased as
to_field. This will be used as the value for the 'To' field when creating an email. We don't really care where the value is going to be used, we only need to know the alias to name it as.
We also need to include the angle brackets before and after the email address.
So pass this step:
- change your double quotes to single when designating the spaces between the words
- Remove the comma right before
to_fieldand replace it with
AS. It should look like
AS to_field(Again, the double quotes are optional on the alias assignment)
- Remove the
- Add the angled brackets to surround the
I hope this helps and g'luck.
Pascal BreitrückPro Student 3,205 Points
Hey my Friend try this. :D
SELECT first_name ||' '|| last_name || ' <'||email||'>' AS "to_field" FROM patrons;