We are adding a column to table with the help of alter table.

ALTER TABLE table_name
ADD column_name datatype;

We fetching all records or data from customers table at where city is london and country is uk with the help of AND operator.

SELECT * FROM Customers
WHERE City = "London" AND Country = "UK";

We fetching all records or data from products table at where price is any given prices with the help of ANY operator.

SELECT * FROM Products
WHERE Price > ANY (SELECT Price FROM Products WHERE Price > 50);

We are doing delete or drop column from table with the help of alter table.

ALTER TABLE table_name
DROP COLUMN column_name;

We modifying column in users table.

ALTER TABLE users
MODIFY COLUMN updated_at TIMESTAMP
DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP;

We renaming column.

ALTER TABLE table_name
RENAME COLUMN old_name to new_name;