ive got this
SELECT first_name || " " || last_name || " " || email AS to_field FROM customers;
I felt like i was close but obviously not close enough, could somebody help me with the answer for this question? driving me mad this is!
Jennifer NordellTreehouse Staff
Hi there, Sandeep Padda ! Indeed, you are very close. First, you are selecting from the wrong table. The table is named "patrons", but you are selecting from "customers". I know they mean the same thing in English, but SQL doesn't know that
Secondly, it actually wants that email to appear in angle brackets just like they have in the example, so somewhere in there you need to concatenate on those brackets. Hint: somewhere in your statement you will need...
" <" || email || ">"
I will leave the placement and the renaming of the table up to you, but you've got this!
Hope this helps!
i stil dont get it, ould you please help with the answer
ok i finally got it! couldnt figure out where to put the angle brackets but this worked
SELECT first_name || ' ' || last_name || ' <' || email || '>' AS to_field FROM patrons;
thank you very much for your help Jennifer!