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
Derek Gella
15,215 PointsSQL 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?
2 Answers
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).
Derek Gella
15,215 Pointsthank you andrew.
Chris Gauthier
Courses Plus Student 6,434 PointsChris Gauthier
Courses Plus Student 6,434 PointsCan you please post the link to your challenge?