BILETUL 14

BILETUL 14

bilet14.a1 - update SALAR14 set SALARIU=SALARIU*1.30 where SALARIU < 500
bilet14.a2 - update SALAR14 set SALARIU=SALARIU*1.25 where SALARIU < 750
bilet14.a3 - update SALAR14 set SALARIU=SALARIU*1.20 where SALARIU >= 750
bilet14.b - select NUME from SALAR14 where SALARIU=(select min(SALARIU) from SALAR14);
bilet14.c - select SALARIU from SALAR14 where SALARIU=(select max(SALARIU) from SALAR14);