BILETUL 15

BILETUL 15

bilet15.a1 - select * from ELEVI15;
bilet15.a2 - select * from NOTE15;
bilet15.b - select a.NUME, a.CLASA, ((b.NOTA_ROMANA+b.NOTA_MATEMATICA)/2) as MEDIA_GENERALA from ELEVI15 a, NOTE15 b where a.numar_matricol=b.numar_matricol
bilet15.c - delete * from ELEVI15 a, NOTE15 b where (a.NUMAR_MATRICOL=b.NUMAR_MATRICOL) and((a.NOTA_ROMANA+b.NOTA_MATEMATICA)/2)<=5.