How to use an alias for a column

      SELECT productID, productName AS name, listPrice AS price 
      FROM products 
      WHERE listPrice < 450 
      ORDER BY listPrice;
      

      SELECT productID, productName name, listPrice price 
      FROM products
      WHERE listPrice < 450 
      ORDER BY listPrice;
      

      SELECT productID AS "ID", productName AS "Product Name", listPrice AS "Price"
      FROM products 
      WHERE listPrice < 450 
      ORDER BY listPrice;
      

Description

• By default, a column in the result set is given the same name as the column in the base table. If that’s not what you want, you can specify a column alias for the column.
• One way to name a column is to use the AS keyword as shown in the first example above. Although the AS keyword is optional, it enhances readability.
• When you enclose an alias in quotes, you can use spaces within the column name.