if after AS we put a column name which is already present then will it replace the old column?

Answer 1

no

Answer 2

if the old column name does not replace the new column name, how then will either of em be referenced relative to the other

Answer 3

yes