I have used the following query:

```
select tblclass.classname,tblattendance.id 
 from tblclass,tblattendance
where tblclass.classcode=tblattendance.classcode 
  and tblattendance.attdate='2013-07-01'

```

Output of this query is as follows:

![enter image description here](https://i.stack.imgur.com/9SjQn.png)

Now what I want is rather than the above result I want count of different classes like IB-2,IC-5.
Please tell me what modifications do I need to made in my query to get the desired result