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

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 --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