I Use RSForm Pro as data collector
I have some fileds in the table (see atachment)
Table name = DNS
I need to create a SQL query that shows data from the table in picture
Field FromDep is one department. and Student is a new meber in tha Department.
So the out data to show should be FromDep x Student

e.g.

Department 1 = 21
Department 2 = 33
Department 3 = 45

And then I'd like to show this with the Google Chart PIE or like a normal Pie or Grapg with bars

Please Help me out

Hello,

Send an SQL dump of "DNS" table with sample data by email.

Regards,
ARI Soft