Answer_Master id_answer answer id_question 1 Yes 1 2 No 1 3 Yes 2 4 No 2 5 Strongly Disagree 3 6 Disagree 3 7 Neither Agree Nor Disagree 3 8 Agree 3 9 Strongly Agree 3 10 Strongly Disagree 4 11 Disagree 4 12 Neither Agree Nor Disagree 4 13 Agree 4 14 Strongly Agree 4 15 Strongly Disagree 5 16 Disagree 5 17 Neither Agree Nor Disagree 5 18 Agree 5 19 Strongly Agree 5
Table log_answer
id_question id_answer id_student 1 1 1 1 1 2 2 3 1 2 4 2 3 9 1 3 8 2 4 13 1 4 13 2 5 17 1 5 18 2
Want to know the count of people answering to different questions
Eg. for question no.3, 5 people say Strongly Disagree, 2 say Agree etc
Reqd. Format as follows:
question_id Strongly_Disagree Agree
3 5 2 4 2 3
Aucun commentaire:
Enregistrer un commentaire