shop items

create table shop(id int,name varchar(20),rate int);
insert into shop values(1,'Tshirts',750);
insert into shop values(2,'Jeanspants',1200);
insert into shop values(3,'Shirts',1000);
insert into shop values(4,'Trousers',900);
select * from shop;
desc shop;
select id,name,rate from shop where rate>1000;
alter table shop add(brand varchar(20));
alter table shop add(madeincountry varchar(20));
select * from shop;
insert into shop values(5,'JeanShort',1100,'USPolo','USA');
alter table shop add(established int);
select * from shop;
update shop set brand='Denim' where name='Tshirts';
update shop set brand='Max' where id=2;
update shop set brand='Roadster' where id=3;
update shop set brand='AllenSolly' where id=4;
update shop set madeincountry='Japan' where id=1;
update shop set madeincountry='China' where id=2;
update shop set madeincountry='India' where id=3;
update shop set madeincountry='UK' where id=4;
update shop set established =2001 where id=1;
update shop set established =1981 where id=2;
update shop set established =1999 where id=3;
update shop set established =2018 where id=4;
update shop set established =1967 where id=5;
select * from shop;
select 100+200 from dual;
select 100+200+300 "sum of three" from dual;
select 100-50 from dual;
update shop set rate=rate+200 where id=1;
update shop set rate=rate+50 where id=2;
select * from shop;
alter table shop add(profits int);
select * from shop;
alter table shop rename column established to year;
alter table shop rename column name to Name;
alter table shop add(loss int);
alter table shop drop column loss;
select * from shop;
delete from shop where id=5;
select * from shop;
select mod(100,10) from dual;
create table student(id int, name varchar(20),age int);
insert into student values(1,'vasu',20);
insert into student values(2,'ram',22);
alter table student add(gender varchar(20));
update student set gender='male' where id=1;
update student set gender='male' where id=2;
select * from student;
select id,name from student;
select id "no",name "person" from student;
alter table student modify id varchar(20);
select * from student;
desc student;