counting multiple columns in a query

Student ID

Command over subject

Teaching Subject

Explaining things

Pedagogy Methods

Solicited_Participation_Class

1

Good

Average

Bad

Good

Bad

2

Bad

Average

Good

Bad

Good

3

Average

Average

Average

Good

Average

4

Average

Good

Good

Average

Average

5

Average

Average

Bad

Average

Good

6

Good

Average

Average

Good

Bad

I have a table given above, table name is student. Which has following sample data.







I want to count the no. of students who say Good, Average ,Bad for every indicator

Output from query:



Good

Average

Bad

Command over subject

2

3

1

Teaching Subject

1

5

0

Explaining things

2

2

2

Pedagogy Methods

3

2

1

Solicited_Participation_Class

2

2

2



How this can be achived from query in MS Access 2010

Thanks a lot

Manoj

counting multiple columns in a query