How to alter column name

alter table <table_name> rename column <old_column_name> to <new_column_name>;

Rename column name to new name.

To rename more than one column

alter table <table_name> rename(old col1,old col2,....) to (new col1,new col2,...);