need perfrom select, join, Sum, Avg, Alter table of this

--Customer Table. create table customers Customer_id number(10) primary key. customer_name varchar(10). mail varchar(201. telephone number) Addresss varchar(10). ordered_product varchar(10%. Item_quantity number 10) -Payment Table create table Paymemt payment_id number[10) primary key, payment type varchar 10 paymen_date date, total_price varchar(101: Shipment - create table shipment shipment_id number(10) primary key. shipment-type varchar(101. shipment_company_name varchar(10), shipment price number 10): -Stall Table- create table Staff sta_id number(10). stat_name varchar(10) position varchar(20), Telephone number 10 mal varchar(10) Supplier table Create table supplert su polier_id number 10). supplier_name varchar(10). email varchar(10). Telephone number (20) ...Product Table create table product product_id number 10%. product_name varchar(10). product_category varchar(10), product_price number(10): ..-Admin table- create table Admin admin_id number(10). admin_name varchar(10). admin_password varchar(10): DoD Payment Payment ID (PK) Payment type 1.1 Payment date Total price Update to 1.1 1..1 Staff inform Staff ID (PK) Staff Name Position Telephone No E-Mail Address 0.. 1.. 1..1 Customer Customer ID (PK) Customer Name E-Mail Address Telephone No. Address Ordered product Item quantity 1.. Deliver Shipment Shipment ID {PK) Shipment type Shipment Company name Shipment price 1..1 1..1 Admin Send Product Supplier Supplier ID {PK) Supplier Name E-Mail Address Telephone No 1... Admin_id {pk) Admin name Admin password * , , , 1.- Buy D Product Product ID (PK) Product Name Product category Product price Add 0.. 1.. 1... Check buyDate Order quantity Total order price