SQL Aliases — a practical guide to SQL aliases AS with clear examples you can reuse in real projects.
SQL Tutorial Series (40/100). Prefer one article? Read the complete SQL tutorial.
Short description
Aliases improve readability and are required for derived tables in many engines.
Aliases
SELECT u.email AS user_email, COUNT(o.id) AS order_count
FROM users AS u
LEFT JOIN orders AS o ON o.user_id = u.id
GROUP BY u.email;