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
Mark Casavantes
Courses Plus Student 13,401 PointsWhere is my error?
In the e-commerce database there's a customer_addresses table with the following columns: id, nickname, street, city, state, zip, user_id.
Select all the columns that are to do with the address. For example, all columns except id, nickname and user_id.
Bummer! You should try writing a SELECT query. // What TeamTreehouse wrote.
> SELECT street, city, state, zip FROM customer_addresses;
Umesh Ravji
42,386 PointsIn an ecommerce database there's a addresses table. There is an id, nickname, street, city, state, zip, country and user_id columns. Concatenate the street, city, state, zip and country in the following format. Street, City, State Zip. Country e.g. 34 NE 12 st, Portland, OR 97129. USA. Alias the concatenated string as address.
If that is your question, you are missing the rest of the query :)
Mark Casavantes
Courses Plus Student 13,401 PointsI added the // to add a comment to show what Team Treehouse wrote in response to my entry. SQL may not use comments like this. I copied the question from Team Treehouse completely.
You would not believe this, but I put in the exact same answer as before and this time it passes as correct.
I was going to copy the link, but now it is unnecessary. Thank you both for your assistance.
1 Answer
Luc de Brouwer
Full Stack JavaScript Techdegree Student 17,939 PointsIf you desire to use comments in SQL put 3 --- instead of two // to comment. As long as the table columns in that table match, the query would perform flawless without returning any error.
Steven Parker
231,271 PointsSteven Parker
231,271 PointsOffhand, this looks like it should work.
Can you provide a link to the challenge page?
Also, what's this part? It doesn't look like it belongs to either the response or the query: