Listing D

insert into

   max_credit

(

   name,

   max_credit

)

values

(

   ‘Bill’,

   select max(credit) from credit_table where name = ‘BILL’

);