Renaming columns If you want the result to have different attribute names,use "AS <new name>"to rename an attribute.For example: Beers(name,manf) SELECT name AS beer FROM Beers WH ERE manf =Anheuser-Busch'; beer Bud Bud Lite MichelobRenaming columns Be e rs ( name , man f) SELE C T nam e A S b e er FROM B e er s W H E R E man f = 'An h euserB u sch'; beer Bud Bud Lite Michelob If you want the result to have different attribute names, use “AS <new name>” to rename an attribute. For example: