Calculate columns value in sql server query

it is an add-on task to calculate totalpracticalavg, totalpracticalpct, totaltheorypct, moduletotalresult with the sql query below: some of the lines have been made up from statement rather than coding task could be done remotely, prefer session start at 9:30pm kuala lumpur time select *, totalattendancepct = (CASE WHEN totalattendance <> 0 then astatusontime * 10 / totalattendance ELSE 0 END), totalpracticalavg = (fpractical1 + fpractical2 + fpractical3 + fpractical4 + fpractical5) / COUNT(IS NOT NULL(5 practicals) ), totalpracticalpct = (totalpracticalavg * 60 ) / 100, totaltheorypct = IS NOT NULL (ftheory * 30) / 100 , moduletotalresult = totalattendancepct + totalpracticalpct + totaltheorypct from ( Select [login to view URL] as fpractical1, [login to view URL] as fpractical2,[login to view URL] as fpractical3, [login to view URL] as fpractical4, [login to view URL] as fpractical5, [login to view URL] as ftheory1, [login to view URL] as evaluation1, [login to view URL] as evaluation2, [login to view URL] as fpaper, [login to view URL] as modulefinalresult, [login to view URL] as modulename, [login to view URL] as moduleid, [login to view URL] as duration, [login to view URL] as briefdesc, [login to view URL] as pimage, [login to view URL] as studentname, (select COUNT(attendancestatus) FROM StudentAttendance sa INNER JOIN TraineeModule tm ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND sa.attendancestatus='ontime' AND [login to view URL] = [login to view URL]) as astatusontime, (select COUNT(attendancestatus) FROM StudentAttendance sa INNER JOIN TraineeModule tm ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND (sa.attendancestatus='late' OR [login to view URL] ='absense') AND [login to view URL] = [login to view URL]) as astatuslateabsense, (select COUNT(attendancestatus) FROM StudentAttendance sa INNER JOIN TraineeModule tm ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND [login to view URL] = [login to view URL]) as totalattendance from StudentResult sr INNER JOIN Module m ON [login to view URL] = [login to view URL] INNER JOIN Student s ON [login to view URL] = [login to view URL] INNER JOIN UserTable ut ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 ) TAB1