LearnSQL Aliases: AS Keyword for Columns & Tables

14 / 61 0%

Lesson 14 of 61

5 mins read

SQL Aliases: AS Keyword for Columns & Tables

In Plain English

SQL aliases assign temporary, readable names to columns or tables using the `AS` keyword. Column aliases format computed expressions in result headers, while table aliases simplify multi-table joins and self-joins.

The Mental Model

"A table alias is like giving a long formal company name a short nickname in conversation (e.g. referring to "ZenCompiler International Logistics Corp" simply as "Z")."

Deep Dive: How It Works

Column Aliases: `SELECT unit_price * quantity AS subtotal FROM cart`. The `AS` keyword is technically optional (`SELECT col name`), but including `AS` is best practice for clarity.

Table Aliases: `FROM orders AS o JOIN customers AS c ON o.customer_id = c.id`. Qualifies columns cleanly (`o.id`, `c.name`).

Identifier Quoting: If an alias contains spaces or special characters, wrap it in double quotes (`AS "Total Price (USD)"`).

Syntax Blueprint

SELECT
  c.first_name AS customer_name,
  o.order_date AS placed_at
FROM customers AS c
JOIN orders AS o ON c.id = o.customer_id;

Use table aliases (c, o) to qualify columns and column aliases for clean output headers.

Core Rules to Remember

Readability in Joins: Table aliases prevent massive verbose query strings when joining multiple tables.

Self-Join Necessity: Table aliases are mandatory when joining a table to itself (e.g. employee -> manager hierarchy).

Accessible in ORDER BY: Column aliases can be referenced in ORDER BY clauses.

Common Beginner Traps & How to Fix Them

Mistake:Attempting to use a column alias in the WHERE clause.

Why it happens: Because WHERE executes before SELECT defines the alias.

How to fix: Repeat the formula in WHERE or wrap in a subquery or Common Table Expression (CTE).

Pro Tip: Keep table aliases short, standard, and mnemonic (e.g. `u` for `users`, `oi` for `order_items`).

Live Interactive Example

Hit Run Code to see it live

Using Column and Table Aliases in Joins

Python 3.12

Output Console

Click "Run Code" to view the rendered output.

How it works: Aliases u and o simplified table references, and AS assigned clean column header labels.

Your Turn: Micro Challenge

No pressure! Edit the starter code below and test your solution with instant feedback.

Micro Exercise

Assign Column Alias with AS

Select `first_name AS name`, `(age * 12) AS age_in_months` from `profiles`.

Sandbox Output

Click "Run & Check" to test your solution.

Finished reading and practicing?

Mark this lesson as completed to update your course progress.