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

Databases

Posted by Sofia Hassan
Sofia Hassan
948 Points

Help with challenge task

In this command below:

SELECT first_name || " " || last_name || " " || email AS "TO" FROM patrons;

How to do I format the email as andrew.chalkley@gmail.com. ?

2 Answers

Steven Parker
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

You're close.

  • don't be confused by that last sentence about marketing - it's not important to the challenge.
  • the challenge says your alias should be to_field, not "TO", and you won't need the quotes.
  • the email address needs to be wrapped in angle brackets. (end your concat group with " <" || email || ">")

I'll bet you can get it now without an explicit spoiler.

Sofia Hassan
Sofia Hassan
948 Points
Sofia Hassan
Sofia Hassan
948 Points

So I tried that and it didn't work > SELECT first_name || " " || last_name || " " || <email> || " " AS to_field FROM patrons;