How to add more strings at the end when concatenate columns using || in SQL?
To get it in this form : Andrew Chalkley email@example.com. How to get the >. at the end into the new column My answer is the following which is wrong SELECT first_name ||" "|| last_name ||" <"|| email ||">."|| AS"to_field" FROM patrons;
Steven Parker176,675 Points
You're really close, but you don't need the extra || symbols between the string and the AS. Also, I don't think you need a period after the ">". Fix those and I think you'll have it!