The following query will imereave

update cringlesyere sel sialary case

when salary $=0.$

when salary $<mtext\; id="EditorElement\_1095416"></mtext><mn\; id="EditorElement\_1095417">0</mn><mn\; id="EditorElement\_1095418">.</mn><mn\; id="EditorElement\_1095419">2</mn><mn\; id="EditorElement\_1095420">8</mn><mtext\; id="EditorElement\_1095421"></mtext><mi\; id="EditorElement\_1095422">"</mi>$ avg ealary then salary $"1\mathrm{.}05$

cloe salary $*1,00$

und.

a$)$ all salaries by $15\%$

b$)$ all salaries by $5\%$

$($c$)$ Dalaries at the bottom by $1$ s$\%,$ the ones at the top by $5\%.$

d$)$ salaries at the top by $15\%,$ the ones at the bottom by $5\%$

c$)$ salaries at the top by $15\%,$ the ones at the bottom by $5\%$ and all others by $1.$

The following query will delete

with avg sal as $($select avg$($salary$)$ from employee$)$

delete from employee where id in $($select

employee.id from

$(($employee join department on employee.dep $=$

department.id$)$

join location on employee.loc $=$

location.id$))$ and city$=$ 'Kars' and salary avg sal:

a$)$ all employees unconditionally

b$)$ all employees if they are located in Kars

c$)$ all employees if they are earning less than $15\%$ of the average salary

d$)$ all employees if they are located in Kars and earning more than $15\%$ of the average salary

e$)$ all employees if they are earning less than $15\%$ of the average salary and located in Kars