select a.full_name, count(*), sum(qa.isCorrect) 
from activity as a
inner join questionAttempt as qa
on a.id = qa.activityid and
qa.studentid = 1
group by a.full_name;