CASE WHEN problem

[Simply Me]

Hi!

I am trying to get the General Average of the students and I want to have the results displayed in column GenAve, GenAve2 and so on... I tried the code below and its working but I dont know how will I make the results be displayed in GenAve and GenAve respectively and also, how do I make the result 77.257000 to display as 77.257?

select IDNO,LastName, FirstName, MI,YearLevel,SectionName,GenAve,GenAve2,
CASE
--First Grading
WHEN YearLevel='LC7' and SectionName='FirstYearSection1' THEN 
 	Round((((Filipino * 1.2) + (English * 1.5) + (Math * 1.5) + (Science * 1.8) + ([Araling Panlipunan] * 1.2) +
		(TLEComputer * 1.2) + (MAPEH * 1.2) + (CLEESP * 0.9) + ([Earth Science] * 1))/11.5),3)

--Second Grading
WHEN YearLevel='LC7' and SectionName='FirstYearSection1' THEN 
 	Round((((Filipino2 * 1.2) + (English2 * 1.5) + (Math2 * 1.5) + (Science2 * 1.8) + ([Araling Panlipunan2] * 1.2) +
		(TLEComputer2 * 1.2) + (MAPEH2 * 1.2) + (CLEESP2 * 0.9) + ([Earth Science2] * 1))/11.5),3)
END

[Simply Me]

by the way I just updating my table. How do I use UPDATE in the above code?

[FunkyDexter]

Your question is very unclear but I think you're after something like this:-
select IDNO,LastName, FirstName, MI,YearLevel,SectionName,
Round((((Filipino * 1.2) + (English * 1.5) + (Math * 1.5) + (Science * 1.8) + ([Araling Panlipunan] * 1.2) + (TLEComputer * 1.2) + (MAPEH * 1.2) + (CLEESP * 0.9) + ([Earth Science] * 1))/11.5),3) as GenAve,
Round((((Filipino2 * 1.2) + (English2 * 1.5) + (Math2 * 1.5) + (Science2 * 1.8) + ([Araling Panlipunan2] * 1.2) + (TLEComputer2 * 1.2) + (MAPEH2 * 1.2) + (CLEESP2 * 0.9) + ([Earth Science2] * 1))/11.5),3) as GenAve2

If that's not what you're after then I think you're going have to be MUCH clearer in your question. Show us some data and the desired result.