Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Charles Fields
4,205 PointsHas anyone been able to satisfy the question of querying to this format? Andrew Chalkley <andrew@teamtreehouse.com>
My answer is SELECT first_name || " " || last_name || " <" || email || ">" AS “to_field” FROM patrons; In the SQL Playground, using the similar table= customers, this yields the expected result: Lauren Chalkley Lauren.Chalkley@example.com Dave McFarland Dave.McFarland@example.com Pasan Premaratne pdawg@example.com Andrew Chalkley Andrew@teamtreehouse.com
I can't help wondering if there's something about the question I don't get. Tried leaving out prefix space before email, adding a period on the end too.
1 Answer
KRIS NIKOLAISEN
54,967 PointsThe fancy/curly quotes around to_field are causing the task to fail. Either remove them or replace them with straight quotes and you should pass.
Charles Fields
4,205 PointsPerfect! Thanks, Kris!
PS I think this happened when I copied an early attempt to MS Word, then copied it back after figuring out an error
Charles Fields
4,205 PointsCharles Fields
4,205 PointsJust noticed, the pasted results dropped the characters "<" and ">" in the details section above, but they were fine in the work space.