What is the need of "column Aliases" in "SELECT" clause?

Solution (By Examveda Team)

Imagine you have a table called "products" with columns like "product_id", "product_name", and "price". You want to display the price of each product, but you want to call it "cost" in your results instead of "price".
This is where column aliases come in handy.
Column aliases let you assign new names to the columns in your SELECT statement's results.
So, the answer is Option D: All of the mentioned.
Let's break down the options:
Option A: This is correct. Column aliases let you give your columns new labels in the result set.
Option B: This is also correct. Column aliases can overwrite existing column names.
Option C: This is also correct. Column aliases are useful when you're working with literals, expressions, or built-in functions in your SELECT clause.
In short, column aliases give you more control over how your query results are displayed.