Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT MIN(SALARIUL) minim, MAX(SALARIUL) maxim,ROUND( AVG(SALARIUL)) mediu
- FROM ANGAJATI;
- SELECT COUNT(DISTINCT SALARIUL) FROM ANGAJATI;
- SELECT a.ID_DEPARTAMENT,DENUMIRE_DEPARTAMENT, MIN(SALARIUL) minim, MAX(SALARIUL) maxim,ROUND( AVG(SALARIUL)) mediu
- FROM ANGAJATI a,DEPARTAMENTE b WHERE a.ID_DEPARTAMENT=b.ID_DEPARTAMENT
- GROUP BY a.ID_DEPARTAMENT,DENUMIRE_DEPARTAMENT;
- CREATE TABLE MY_EMP AS SELECT * FROM ANGAJATI;
- CREATE TABLE MY_DEPT AS SELECT * FROM DEPARTAMENTE;
- CREATE TABLE MY_JOBS AS SELECT * FROM FUNCTII;
- SELECT NUME,SALARIUL,ID_DEPARTAMENT FROM MY_EMP a, MY_JOBS b
- WHERE a.ID_FUNCTIE=b.ID_FUNCTIE and DENUMIRE_FUNCTIE ='Programmer';
- SELECT NUME,SALARIUL,ID_DEPARTAMENT,DENUMIRE_FUNCTIE FROM MY_EMP a, MY_JOBS b
- WHERE a.ID_FUNCTIE=b.ID_FUNCTIE and DENUMIRE_FUNCTIE LIKE '%Manager';
- SELECT NUME,SALARIUL,DATA_ANGAJARE
- FROM MY_EMP a,MY_DEP g
- WHERE a.ID_DEPARTAMENT=g.ID_DEPARTAMENT AND DENUMIRE_DEPARTAMENT='Sales'
- ORDER BY SALARIUL ASC, DATA_ANGAJARE DESC;
- SELECT NUME,COMISION,DENUMIRE_FUNCTIE
- FROM MY_EMP a,MY_JOBS b
- WHERE a.ID_FUNCTIE AND b.ID_FUNCTIE AND DENUMIRE_DEPARTAMENT='Sales'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement