deleted the duplicate occurrence of the "AS" keyword