SELECT sc.stuno, SUM(sc.score*co.credit)/SUM(co.credit) as avgScore
FROM [PowerBI].[dbo].[score] as sc
inner join [PowerBI].[dbo].[course] as co
on sc.couno=co.couno
group by sc.stuno