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 SQL Basics Getting Data from a Database Categorizing Your Output with 'AS'

Posted by Victor Melvin
Victor Melvin
1,679 Points

What is wrong with my syntax on this AS output Query ?

SELECT first_name AS "First Name",last_name AS "Last Name",phone AS "Phone Number" FROM users;
I want the first name,last name, phone number from the table "users". I keep getting a return message that says I have an error in my code. What is wrong with it ?

1 Answer

Steven Parker
Steven Parker
231,275 Points
Steven Parker
Steven Parker
231,275 Points

It looks like you're on task 3. The instructions say "In the phone_book we have the columns id, first_name, last_name and phone.".

But your query is looking for a "users" table instead of "phone_book".