Queries8 / 14
Up next

Alias a table

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;
What you're solving

short table name for readability