skip to today's puzzle

AS gives a column a clearer name

AS renames a column in the result you see — a label on the output, nothing more. The table itself doesn't change. It's most useful for calculations or cryptic column names, giving your results a clear, descriptive heading.

A tiny example

In plain English: Show me every order’s total, with the column labeled receipt_total.

SELECT total AS receipt_total
FROM orders;

Query result

receipt_total
8.5
12
4.75

The values are the same order totals — AS only changed the heading above them.

Related SQL lessons

Ready for a break?

A fresh, bite-sized SQL puzzle waits every morning. Tap tiles, see real results. No terminal, no setup, no timers.

Try today's free SQL puzzle