IT CODE 402 UNIT 3 SESSION 6 PRACTICAL ASSIGNMENT QUESTION 1

/* practical assignment*/
-- it code 402 pg 199
-- QUESTION 1
create table gym (
icode text,
iname varchar(20),
price int,
brandname char(20)
);

desc gym;

-- QUESTION 2
insert into gym values('G101','POWER FIT EXERCISER',20000,'POWER GYMEA');
insert into gym values('G102','AQUAFIT HAND GRIP',1800,'POWER GYMEA');
insert into gym values('G103','CYCLE BIKE',1400,'reliable');
insert into gym values('G104','PROTONER EXTREME GYM',2000,'POWER GYMEA');
insert into gym values('G105','MESSAGE BETL',30000,'POWER GYMEA');
insert into gym values('G106','CROSS TRAINER',130000,'coscore');

-- QUESTION 3

select * from gym where iname like 'A%';

-- QUESTION 4

select icode,iname from gym where brandname in ('reliable','coscore');

-- QUESTION 5

update gym set brandname = 'fit trend india' where icode = 'G101';
select * from gym;

-- QUESTION 6
insert into gym values('G107','VIBRO EXERCISER',2100,'GTC FITNESS');
select * from gym;