Hi I have below data in one of the table, can any one help in creating the query to meet my requirement.
ResponseId FormSectionId SelectedValueId Rating ManagementInfo
1 1 22 1 Y
1 1 23 5 Y
2 2 14 N
2 2 21 4 Y
I want to find the avg of rating and top selected managementinfo(y or n) on formsection columns.
For ex: formsection 1 & 2 has avg rating as 4, and top management is Y.
can any one pls help.