Count db result from MySQL

Question

I want count the result from table.

Table looks like this(row data),

Que is question and answer is Answer, and answer most have a value of 1 to 5, but it can vary depending on the question.(like 1 to 9)

The image above is only part and the question is from 1 to 13. The rows in the table repeat over and over again.

I'd like to know the percentage of answers to each question.

I try to count,

SELECT COUNT(*) FROM survey.surveys WHERE exhibition_id = 2 GROUP BY que;

But this is just count by que

How I can count it?

I want result like,

que | answer | count(answer)
 1  |   1    |    30
 1  |   2    |    27
 1  |   3    |    28
 1  |   4    |    31
 1  |   5    |    30
 2  |   1    |    17
 2  |   2    |    23
 2  |   3    |    31
 2  |   4    |    45
 2  |   5    |    29

"'d like to know the percentage of answers to each question." - what does this mean? Please provide example desired output results. — Dai
– Dai, Commented Nov 11, 2019 at 5:02

CompEng · Accepted Answer · 2019-11-11 05:04:16Z

1

You should group by answers

SELECT COUNT(*) FROM survey.surveys WHERE exhibition_id = 2 GROUP BY answers

answered Nov 11, 2019 at 5:04

CompEng

7,41618 gold badges77 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Polaris Nation Over a year ago

But in that case, the result does not take into account the question.

CompEng Over a year ago

You can add case when statement according your wish

Polaris Nation Over a year ago

Could you elaborate a little?

Polaris Nation Over a year ago

Sorry, It's simple of that. Thanks you for your answer

Harshwardhan Sharma · Accepted Answer · 2019-11-11 05:37:05Z

0

Try this

SELECT que,answer,count(answer) FROM survey.surveys WHERE exhibition_id = 2 GROUP by answer order by que asc

answered Nov 11, 2019 at 5:37

Harshwardhan Sharma

2611 silver badge12 bronze badges

Collectives™ on Stack Overflow

Count db result from MySQL

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related