When you want the column name of the table to appear differently in your SQL query, just to make sure that you too can do some magic, you can use aliases. Though aliases can also be created for various database objects like tables, views, stored procedures and macros, it is the column aliases that are [...]

A derived column is a result of a calculation (most of the time mathematical) that happens during the SQL query processing and generates a new column which is not part of the original table definition. For example, in our table we have salary column present but when we want to extract a percentage of the [...]