At times, especially for generating reports, we might want to give a different column name or an alias to a table.
For example, in our example, we can use the following statement to change the artiste column to name.
select artiste as Name, album, price from artist
Another simple example is:
select now() as Date;