Answers for "access SQL change column name in SQL output"

how to change the column name in sql

ALTER TABLE table_name
CHANGE COLUMN old_name TO new_name;

changing column names in sql query results

SELECT NAME AS "Employee Name" FROM PEOPLE;

SELECT p.NAME AS "Employee Name", s.SALARY AS "Employee Salary"
FROM PEOPLE p
JOIN SALARIES s ON p.ID = s.ID;