Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Average Score per Question

Return each question and its average score rounded to 2 decimals, ordered by question.

Table schema

Responses(id INT PRIMARY KEY, respondent INT, question INT, score INT)

Sample data

id | respondent | question | score
1 | 1 | 1 | 9
2 | 1 | 2 | 4
3 | 2 | 1 | 7
4 | 2 | 2 | 5
5 | 3 | 1 | 10
6 | 3 | 2 | 5
7 | 4 | 1 | 3

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.