Multiple Aliases
sql
1SELECT
2 name AS student_name,
3 course AS enrolled_course,
4 marks AS total_score
5FROM students;With Functions
sql
1SELECT COUNT(*) AS total_students FROM students;Without AS
AS is optional (but recommended for clarity):
sql
1SELECT name student_name FROM students;