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
MaryAnn Eleanya
8,626 PointsI don't know why my SQL answer isn't being accepted.
The problem keeps saying I should select a query but I have no idea what I am doing wrong.
MaryAnn Eleanya
8,626 PointsHi Jennifer I've tried a few different things such as changing the words "SELECT" and "FROM" from capital cases to small cases but that still didn't work.
This is the link to the problem; https://teamtreehouse.com/library/sql-basics/getting-data-from-a-database/retrieving-specific-columns-of-information-2
Challenge Task 1 of 5 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.
Type in your command below.
SELECT first_name, last_name FROM users;
1 Answer
Jennifer Nordell
Treehouse TeacherHi there! Well, the good news is that there's nothing wrong with your code that I can find. If I copy/paste your code into the challenge and run the check on it, it passes with flying colors! This, however, makes me wonder why it isn't passing on your end. My best suggestion to you right now is to copy/paste the code you put here and restart the challenge completely. I feel like there may be some cached data somewhere that is throwing something off.
Hope this helps!
MaryAnn Eleanya
8,626 PointsThanks! It worked.
Jennifer Nordell
Treehouse TeacherJennifer Nordell
Treehouse TeacherHi there! To assist you, we will need some additional information. First, it would be interesting to know what you've tried thus far. Secondly, a link to the challenge would be immensely helpful so that we can see the challenge requirements.