Advertisement
halexandru11

26 BD

Dec 22nd, 2020
112
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT NUME, PRENUME, NOTA FROM ELEVII
  2. INNER JOIN NOTE ON ELEVII.CNP = NOTE.CNP_ELEV
  3. WHERE EXTRACT(MONTH FROM DATA) = 3 AND UPPER(MATERIA) = :MATERIE
  4.  
  5. SELECT AVG(NOTA) AS "MEDIA NOTELOR" FROM NOTE
  6. WHERE EXTRACT(YEAR FROM DATA) = 2010 AND UPPER(MATERIA) = 'INFORMATICA'
Advertisement
RAW Paste Data Copied
Advertisement