Changing this alias will result in a duplicate output column name.

The modification you are trying to make will yield a query in which several output columns have the same name. You must explicitly supply unique aliases for each output column.