create table product(id varchar2(10),product namevarchar2(20),price number(5),quantity number(5));
insert into product values(001,'mouse',4000,5);
insert into product values(002,'keyboard',6000,8);
insert into product values(003,'printer',7000,6);
insert into product values(004,'cpu',9000,10);
insert into product values(005,'monitor',8000,9);
select*from product;
select count(*)from product;
select max (quantity) from product;
select min(quantity)from product;
select min(quantity)from product where id=001;
alter table product add productdelivered number;
update product set productdelivered=40 where id=002;
update product set productdelivered=49 where id=003;
update product set productdelivered=50 where id=004;
select*from product;
select sum(productdelivered)from product;
select avg(quantity)from product;
select*from product;