```
Table: call_details
-------------------
userId

phoneNumber

callDate

callType

callDuration

```

Now I want a query to fetch details based on date and type.

Like, I want SUM of total count of callType for the date.

```
28-03-2014 - there are total 1 missed call, 2 incoming call and 5 outgoing calls

29-03-2014 - there are total 0 missed call, 5 incoming call and 10 outgoing calls.

30-03-2012 - there are total 5 missed call, 10 incoming call and 35 outgoing calls.

```

My Query - 

```
SELECT `callType`, `callDate`, count(`callType`) as type FROM `tbl_call_details` GROUP BY `callType` ORDER BY `callDate` ASC

callType    callDate    count

OUTGOING    2014-03-28  52
INCOMING    2014-03-30  11
MISSED  2014-03-31  1

```

Result is wrong as its not giving me separate results date wise. Its just picking dates coming in database and displaying everything. I want results separated date wise for all the types with their count on all day.