BILETUL 9

BILETUL 9

bilet9.a - select * from MISCARI9
bilet9.b1 - select sum (PRET_UNITAR*CANTITATE) as "Valoarea articolelor intrate" from MISCARI9 where TIP_DOCUMENT='NIR'
bilet9.b2 - select sum (PRET_UNITAR*CANTITATE) as "Valoarea articolelor iesite" from MISCARI9 where TIP_DOCUMENT='AEE'
bilet9.c - delete from MISCARI9 where DATA_DOCUMENT between ('01-apr-2008')and ('30-apr-2008');