--How many credits has the student taken? select sum(credits) as totalSum from Courses join Students on Students.pNbr where pNbr = '790101-1234'