aliases in sql

 SELECT column_name AS alias_name

 FROM table_name;