Question

Consider the table Personal given below:

Table: Personal
P_ID	Name	Desig	Salary	Allowance
P01	Rohit	Manager	89000	4800
P02	Kashish	Clerk	NULL	1600
P03	Mahesh	Superviser	48000	NULL
P04	Salil	Clerk	31000	1900
P05	Ravina	Superviser	NULL	2100

Based on the given table, write SQL queries for the following:

1. Increase the salary by 5% of personals whose allowance is known.
2. Display Name and Total Salary (sum of Salary and Allowance) of all personals. The column heading ‘Total Salary’ should also be displayed.
3. Delete the record of Supervisors who have salary greater than 25000.

Answer 1

1. UPDATE Personal
   SET Salary=Salary*1.05 
   WHERE Allowance IS NOT NULL;
2. SELECT Name, Salary+Allowance AS
   "Total Salary" FROM Personal;
3. DELETE FROM Personal
   WHERE Salary>25000