Databases SQL Basics Getting Data from a Database Categorizing Your Output with 'AS'

Victor Melvin
Victor Melvin
413 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
179,852 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".