calculation of subqueries HELP

[DukeSnyder]

I am trying to divide 2 subqueries. there is a comment in the query pointing out what I have unsuccessfuly tried. Can anyone lead me in the right direction please.


SELECT TOP 100 PERCENT dbo.tCourseDesc riptions.Course Name, dbo.nrcAssignme nts.AssignmentT itle, dbo.nrcAssignme nts.AssignmentD ueDate,
dbo.nrcStandard .StandardAbbrev iation, dbo.nrcStandard .StandardDescri ption, dbo.nrcStandard .StateStandardI D, dbo.nrcStandard .StandardName,d bo.nrcAssignmen ts.SKAssignment ID,
(SELECT AVG(FinalGradeT otal) FROM dbo.nrcAssignme ntGrades WHERE FKASsignmentID = dbo.nrcAssignme nts.SKAssignmen tID AND Omitted <> '1') As MaxPoints,
(SELECT ROUND(AVG(Grade PointValue),0) FROM dbo.nrcAssignme ntGrades WHERE FKASsignmentID = dbo.nrcAssignme nts.SKAssignmen tID AND Omitted <> '1')As ClassAvg,
(SELECT SUM(FinalGradeT otal) FROM dbo.nrcAssignme ntGrades WHERE FKASsignmentID = dbo.nrcAssignme nts.SKAssignmen tID AND Omitted <> '1') As MaxTotal,
(SELECT SUM(GradePointV alue) FROM dbo.nrcAssignme ntGrades WHERE FKASsignmentID = dbo.nrcAssignme nts.SKAssignmen tID AND Omitted <> '1')As GPSum


-- here are the subqueries I am trying to divide.
-- I am trying to get a TRUE class average
---------------------------------------------------
,CASE WHEN 'ClassAvg' <> 0.0 THEN
((SELECT SUM(FinalGradeT otal) FROM dbo.nrcAssignme ntGrades WHERE FKASsignmentID = dbo.nrcAssignme nts.SKAssignmen tID AND Omitted <> '1')/
(SELECT SUM(GradePointV alue) FROM dbo.nrcAssignme ntGrades WHERE FKASsignmentID = dbo.nrcAssignme nts.SKAssignmen tID AND Omitted <> '1')) ELSE 0 END As MyAvg
------------------------------------------------------




FROM dbo.tStudentEnr oll INNER JOIN
dbo.tSchedule ON dbo.tStudentEnr oll.FKClassID = dbo.tSchedule.S KClassID INNER JOIN
dbo.tCourseDesc riptions ON dbo.tSchedule.F KCourseID = dbo.tCourseDesc riptions.SKCour seID INNER JOIN
dbo.nrcxAssignm entSkills ON dbo.tStudentEnr oll.FKClassID = dbo.nrcxAssignm entSkills.FKCla ssID INNER JOIN
dbo.nrcAssignme nts ON dbo.nrcxAssignm entSkills.FKAss ignmentID = dbo.nrcAssignme nts.SKAssignmen tID INNER JOIN
dbo.nrcStandard ON dbo.nrcxAssignm entSkills.FKSta ndardID = dbo.nrcStandard .SKStandardID
GROUP BY dbo.tStudentEnr oll.FKClassID, dbo.tCourseDesc riptions.Course Name, dbo.tCourseDesc riptions.Academ icYear,
dbo.nrcxAssignm entSkills.FKSta ndardID, dbo.nrcAssignme nts.AssignmentT itle, dbo.nrcAssignme nts.AssignmentD ueDate,
dbo.nrcStandard .StandardAbbrev iation, dbo.nrcStandard .StandardDescri ption, dbo.nrcStandard .StateStandardI D,
dbo.nrcStandard .StandardName,d bo.nrcAssignmen ts.SKAssignment ID
HAVING (dbo.tStudentEn roll.FKClassID = 11204)
ORDER BY AssignmentDueDa te DESC