AS

Renames a column or table with an alias for display, does not permanently change table/column names in the database.

SELECT student_name AS 'student',
  overall_gpa AS 'gpa',
  is_honor_student AS 'Honor Student'
FROM students;