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

vona goodpaster
vona goodpaster
530 Points

I am no sure why my code is incorrect for challenge task 3 of 4.

Question: Challenge Task 3 of 4 We're now back with the smartphone database. In the phone_book we have the columns id, first_name, last_name and phone. Alias the first and last names and phone as "First Name", "Last Name" and "Phone Number".

My answer: Select phone AS "Phone Number", first_name AS "First Name" , last_name AS "Last Name" from phone_book;

3 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
53,512 Points

The task wants you to select the columns in the order requested: first name, last name, then phone

Timothy Sawyer
Timothy Sawyer
28,599 Points

As Kris stated, the exercise just wants you to use SELECT and Alias the first_name last_name and phone as "First Name", "Last Name" and "Phone Number".

SELECT first_name AS "First Name", last_name AS "Last Name", phone AS "Phone Number" FROM phone_book;