Page 105 - IPP-12-2024

(l) To increase the charges of all the patients by 5%.

(m) To remove the record of the patient whose Name is Tarun.

(n) To add another column WardNumber of the type Number in the above table.

(o) To set charges to NULL for all the patients in the Surgery department.

(p) To decrease the charges by 10% of all the patients admitted in the Cardiology department.

(q) To insert a new row in the HOSPITAL table with the following data:
(11,'Mustafa',37,'ENT','1998-02-25',250,'IM')

I Insert into hospital values(11,'Mustafa',37, "ENT", "1998-02-25",250, "M");

(r) Give the output of the following SQL statements based on the above table -
HOSPITAL.