CREATE TABLE department (id INTEGER, name TEXT, budget INTEGER);
INSERT INTO department VALUES (1, 'Sales', 50000), (2, 'Eng', 120000);
-- d is a short alias used to qualify columns
SELECT d.name, d.budget
FROM department AS d;short table name for readability