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 Jayson Santos
Jayson Santos
574 Points

I dont know what to code but I did was below. please help. Thanks

Here are the columns in a users table in an e-commerce site: id, username, password, first_name, last_name. Run a SQL query to get the two columns you'd need to generate the full names of each customer.

and i code

SELECT <column1>, <column2>, <column3>, <column4>, <column5>, FROM users;

Steven Parker
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

This seems to be a more complete version of a previous question. You might want to delete the old one.

2 Answers

Steven Parker
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

You need to refer to the columns by name.

Also, the challenge says it is expecting "to get the two columns".

SELECT first_name, last_name FROM users;

In future questions, remember to include a link to the course page to allow for answer verification.

Jayson Santos
Jayson Santos
574 Points
Jayson Santos
Jayson Santos
574 Points

thanks you so much for the answer.