CREATE TABLE employee (id INTEGER, first TEXT, salary INTEGER);
INSERT INTO employee VALUES (1, 'Ada', 90000), (2, 'Linus', 85000);
-- AS gives a result column a friendlier name
SELECT first AS name, salary AS annual_pay
FROM employee;

column aliases with AS