select t.Tname, avg(SC.score)
from SC join Course as c on SC.CID = c.CID
join Teacher as t on c.tid = t.tid
group by t.tid
select c.Cname, count(SC.SId) as PassingNumber
from SC join Course
select t.Tname, avg(SC.score)
from SC join Course as c on SC.CID = c.CID
join Teacher as t on c.tid = t.tid
group by t.tid
select c.Cname, count(SC.SId) as PassingNumber
from SC join Course