Rename Columns with SQL-Derived Tables

If a derived column list is included for a SQL-derived table, it follows the name of the SQL-derived table and is enclosed in parentheses.

For example:
select dt_b.book_title, dt_b.tot_sales
   from (select title, total_sales
            from titles) dt_b (book_title, tot_sales)
   where dt_b.book_title like "%Computer%"

The column names title and total_sales in the derived-table expression are respectively renamed to book_title and tot_sales using the derived column list. The book_title and tot_sales column names are used in the rest of the query.

Note: SQL-derived tables cannot have unnamed columns.