Questão 2403926

SELECT d.nome, AVG(m.nota) as media

FROM DISCIPLINA d INNER JOIN MATRICULA m

ON d.sigla = m.sigla

GROUP BY d.nome

SELECT d.nome, SUM(m.nota) as media

FROM DISCIPLINA d INNER JOIN MATRICULA m

ON d.sigla = m.sigla

GROUP BY d.nome

SELECT d.nome, AVG(m.nota) as media

FROM DISCIPLINA d INNER JOIN MATRICULA m

ON d.sigla = m.RA

GROUP BY d.nome

SELECT d.nome, AVG(m.nota) as media

FROM DISCIPLINA d, MATRICULA m

WHERE m.nota > 0

GROUP BY d.nome