How I can chage a column name

1

Hello Guys
I want to change the name of the column which I have created from price1 to new_price.

How I can do this?

SELECT product_id, name, price,
case
WHEN price > 100 AND name!='икра'then price1.05
else price end
FROM products
ORDER by price1.05 desc, product_id

2

SELECT product_id, name, price,
case
WHEN price > 100 AND name!='икра' then price * 1.05
else price end as new_price
FROM products
ORDER by new_price desc, product_id

3

ALTER TABLE table_name RENAME COLUMN oldcolumn_name to newcolumn_name;

4

Thanks done