How to Query more than one Col1 in Col2?

[newbieBrian]

Hi all,

I have a table with two columns called for example instructor and class
one instructor may teach more than one class. How can I query how many classes each instructor teaches?

Let me make up the table.

Instructor Class

Mr. A physics
Mr. A Calculus
Ms.B Cooking for dummy
Ms.B English

Thanks

[amitpatel66]

Hi all,

I have a table with two columns called for example instructor and class
one instructor may teach more than one class. How can I query how many classes each instructor teaches?

Let me make up the table.

Instructor Class

Mr. A physics
Mr. A Calculus
Ms.B Cooking for dummy
Ms.B English

Thanks

HINT: Make use of COUNT(class) and GRUOP BY instructor in the SELECT query

Please POST what you have tried?

[newbieBrian]

HINT: Make use of COUNT(class) and GRUOP BY instructor in the SELECT query

Please POST what you have tried?

[CODE=mysql]select instructor ,count(instruct or) from ThisTable group by instructor;[/CODE]

I think it will work. My mine was dump yesterday. Thanks.

[mwasif]

Well done newbieBrian. This query will work for you. If you also need the classes with the instructer, you can use GROUP_CONCAT() to get a list of comma separated classes.

[amitpatel66]

[CODE=mysql]select instructor ,count(instruct or) from ThisTable group by instructor;[/CODE]

I think it will work. My mine was dump yesterday. Thanks.

Good work NewbieBrian :)
I appreciate

MODERATOR