SELECT NUME,SALARIUL,ID_FUNCTIE,
CASE
WHEN UPPER(ID_FUNCTIE)='IT_PROG' THEN SALARIUL*0.2
WHEN UPPER(ID_FUNCTIE)='AD_PRES' THEN SALARIUL*0.1
ELSE SALARIUL*0.05
END AS MAJORARE
FROM ANGAJATI;

SELECT NUME,SALARIUL,ID_FUNCTIE,
DECODE(UPPER(ID_FUNCTIE), 'IT_PROG', SALARIUL*0.2,'AD_PRES',SALARIUL*0.1,SALARIUL*0.05) AS MAJORARE
FROM ANGAJATI;

SELECT NUME,SALARIUL,ID_FUNCTIE,
CASE
WHEN ((SYSDATE-DATA_ANGAJARE)/365 )<5 THEN 1000
WHEN ((SYSDATE-DATA_ANGAJARE)/365) BETWEEN 5 AND 10 THEN 2000
ELSE 3000
END AS BONUS
FROM ANGAJATI;


SELECT COUNT(ID_ANGAJAT), SUM(SALARIUL), AVG(SALARIUL), COUNT(COMISION)
FROM ANGAJATI;

SELECT ID_DEPARTAMENT,COUNT(ID_ANGAJAT)
FROM ANGAJATI
GROUP BY ID_DEPARTAMENT;

SELECT ID_DEPARTAMENT,COUNT(ID_ANGAJAT)
FROM ANGAJATI
GROUP BY ID_DEPARTAMENT
HAVING COUNT(ID_ANGAJAT)>5;

SELECT ID_DEPARTAMENT,COUNT(ID_ANGAJAT) AS NR
FROM ANGAJATI
WHERE SALARIUL BETWEEN 4000 AND 10000
GROUP BY ID_DEPARTAMENT
HAVING COUNT(ID_ANGAJAT)>5
ORDER BY NR DESC;

SELECT CATEGORIE , COUNT (ID_PRODUS)
FROM PRODUSE
GROUP BY CATEGORIE;

SELECT SUM(PRET*CANTITATE), NR_COMANDA
FROM RAND_COMENZI
GROUP BY NR_COMANDA;

SELECT SUM(PRET*CANTITATE), NR_COMANDA
FROM RAND_COMENZI
WHERE NR_COMANDA IN
(SELECT NR_COMANDA
FROM COMENZI
WHERE EXTRACT(YEAR FROM DATA)=2000)
GROUP BY NR_COMANDA
HAVING COUNT(ID_PRODUS)>5;