Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1
- select cod_localitate, cod_magazin, cod_prajitura, count(data_achizitie)
- from magazin join prajitura using (cod_magazin)
- join cumpara using (cod_prajitura)
- where to_char(data_achizitie, 'DD-MON-YYYY') <= '10-JAN-2019'
- and 500 <= (select count(data_achizitie)
- from cumpara)
- and telefon not null
- group by cod_localitate, cod_magazin, prajitura
- order by cod_magazin
- order by cod_prajitura desc;
- --2
- select nume, prenume
- from client join cumpara using (cod_client)
- join prajitura using (cod_prajitura)
- join magazin using (cod_magazin)
- where cantitate in (
- select cod_client, max(cantitate)
- from prajitura
- group by cod_client)
- and cod_localitate=1;
- --3
- select cod_prajitura, denumire
- from prajitura join cumpara using (cod_prajitura)
- where cod_prajitura in (--1
- select cod_localitate, cod_magazin, cod_prajitura, count(data_achizitie)
- from magazin join prajitura using (cod_magazin)
- join cumpara using (cod_prajitura)
- where to_char(data_achizitie, 'DD-MON-YYYY') <= '10-JAN-2019'
- and 500 <= (select count(data_achizitie)
- from cumpara)
- and telefon not null
- group by cod_localitate, cod_magazin, prajitura
- order by cod_magazin
- order by cod_prajitura desc;
- --4
- create table angajati (
- cod_angajat number(4) constraint cod_ang_pk primary key,
- nume varchar2(20) constraint nume_not_null not null,
- presnume varchar2(20),
- cod_magazin number(10) constraint cod_mag_fk foreign key(cod_magazin)
- references magazine(cod_magazin),
- data_nastere varchar2(10));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement