What does an alias do when coded in the 'front' statement?

Question

1. Renames columns so they can be used in the 'group by' and 'order by' statements with more readable names
2. Renames columns so they can be used in the 'where' and 'having=' statements to make the query more readable
3. Renames tables in the query to make the query more readable
4. Renames the calculations in the query to make the query more readable

Which one

Answer 1

Do you mean " from". Statement?