you mean it isn't correct???

create trigger trigger_price

on Tbl_Flight

for insert

as

if adult = 1

begin

insert into Tbl_Flight(price) values (1500000)

return

end

else

if child = 1

begin

insert into...

but

update movie

set price = case when movieName = 'fofo' then 12000*2 when movieName = 'lili' then 25000/2 end

where movieName in ('fofo', 'lili')

doesn't work