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 * from personal;
select roll no, name from personal;
select sum(score) from personal ;
alter table personal rename score to core;
update  personal set 'address' = 'chn' where name = 'AYAN';
select * from personal where name = 'A%' ;