Learn SQL
AS operator
15.3
Lesson

AS - another example

We want to display all distinct courses. To highlight that this list is different from all courses list, we want to give it an appropriate name.

We can use AS to achieve the goal.

Next, suppose we want to display all ages of students and we want the column header to be students_age.