26 BD

SELECT NUME, PRENUME, NOTA FROM ELEVII
INNER JOIN NOTE ON ELEVII.CNP = NOTE.CNP_ELEV
WHERE EXTRACT(MONTH FROM DATA) = 3 AND UPPER(MATERIA) = :MATERIE

SELECT AVG(NOTA) AS "MEDIA NOTELOR" FROM NOTE
WHERE EXTRACT(YEAR FROM DATA) = 2010 AND UPPER(MATERIA) = 'INFORMATICA'