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

Derek Gella
Derek Gella
15,215 Points
Posted by Derek Gella
Derek Gella
15,215 Points

SQL Query isn't satisfying challenge

SELECT first_name || " " || last_name || " <" || EMAIL || ">" AS "TO_FIELD" FROM PATRONS;

Can someone please tell me why this is not satisfying the requirements of the challenge?

Chris Gauthier
Chris Gauthier
Courses Plus Student 6,434 Points

Can you please post the link to your challenge?

2 Answers

Andrew Blackwell
Andrew Blackwell
13,264 Points
Andrew Blackwell
Andrew Blackwell
13,264 Points

@Chris - the challenge is https://teamtreehouse.com/library/reporting-with-sql/working-with-text/concatenating-text

@Derek: it's a small thing: the challenge specifies aliasing to "to_field", not "TO_FIELD". If you write it in lower case, it should work. Treehouse is basically sticking to a widely used convention for SQL here, which is that all SQL syntax is written UPPER CASE, and everything else lower case (or Title Case) (so in a strict world, you'd also write "email" and "patrons" in lower case to make it more legible, but the result is the same).