Learn

Knowing how SELECT works, suppose we have the code below:

SELECT name AS 'Titles'
FROM movies;

Can you guess what AS does?

AS is a keyword in SQL that allows you to rename a column or table using an alias. The new name can be anything you want as long as you put it inside of single quotes. Here we renamed the name column as Titles.

Some important things to note:

  • Although it’s not always necessary, it’s best practice to surround your aliases with single quotes.
  • When using AS, the columns are not being renamed in the table. The aliases only appear in the result.

Instructions

1.

To showcase what the AS keyword does, select the name column and rename it with an alias of your choosing.

Place the alias inside single quotes, like so:

SELECT name AS '______'
FROM movies;

Note in the result, that the name of the column is now your alias.

2.

Edit the query so that instead of selecting and renaming the name column, select the imdb_rating column and rename it as IMDb.

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?