DBMS PRACTISE

create table personal(
 name varchar(10),
 roll numeric(10) not null,
 address varchar(20),
 score numeric(20)
);

insert into personal values( 'AYAN' , 1 ,'KOL', 1234);
insert into personal values('NIKHIL', 2, 'KOL', 2134);
insert into personal values('RAMU', 3, 'DEL', 4321 );
insert into personal values('SHYAM', 4, 'DEL', 1122);
insert into personal values('MRINAL', 5 ,'KOL', 1212 );

select roll no, name from personal;
select sum(score) from personal ;
update  personal set 'address' = 'chn' where name = 'AYAN';
select * from personal;
select *from personal where name  like '%l%' or name ='AYAN';
select *from personal where roll = 3 or name like 'A%';