SELECT SUM(CargaHoraria)

FROM Disciplina

WHERE Nome = 'Alberto Santos Dumont';

SELECT SUM(Disciplina.CargaHoraria) AS TotalCargaHoraria

FROM Disciplina

JOIN Professor ON Disciplina.id_Professor = Professor.id_Professor

WHERE Professor.Nome = 'Alberto Santos Dumont';

SELECT SUM(CargaHoraria)

FROM Disciplina

JOIN Professor ON Disciplina.id_Professor = Professor.id_Professor

WHERE Disciplina.Nome = 'Alberto Santos Dumont';

SELECT SUM(CargaHoraria)

FROM Disciplina

WHERE id_Professor = 'Alberto Santos Dumont';

SELECT Professor.Nome, SUM(Disciplina.CargaHoraria)

FROM Disciplina

JOIN Professor ON Disciplina.id_Disciplina = Professor.id_Professor

WHERE Professor.Nome = 'Alberto Santos Dumont'

GROUP BY Disciplina.id_Professor;