Aliases
Aliases are use to give a table or column a temporary name. They can also make columns and table names more readable. The AS keyword is used to set the alias, comes between the table or columns name and the alias name.
Note
Backticks should be use for table, column and alias names that have spaces in them.
SELECT AVG(book_pages) AS `Average Number of Pages` FROM books;