quote:

---

Originally posted by prashantdighe

Hi all,

I have stuck with some freaking problem....

Following table which i have to deal....

[Session_Type_ID] [Cntribution][Learning] [Intellectual]
1 9 10 0
2 5 7 8
3 4 2 9
4 5 9 5
[Effectiveness] [Program_Name] [Session_Title] [Session_Taken_By]
5 KBC ASP.NET PRASHANT
7 KBC SQL TARUN
6 KBC VB.NET MAYUR
8 XYZ HTML RAJIV
I have to select Contribution, Learning, Intellectual, Effectiveness in such a way so that the rating of below 3 and above 10 will not be counted as well as the average of them counted in group of Session_Taken_By and Session_Title and for same program name

Please help!!!!!!!!

---

SELECT
	*,
	AVG(effectiveness*1) OVER (PARTITION BY [Program_Name]) AS Average
FROM
	YourTable
WHERE
	Effectiveness >= 3 AND Effectiveness <= 10;