SQL how to Count -

i have database phone , track on dates how many phone call or how many sms being period of 1 week example

database:phone  type | date/time  calls           | 04/01/14 0800hrs  sms            | 04/01/14 0850hrs  sms            | 04/01/14 0900hrs  calls           | 04/01/14 1230hrs  sms            | 04/01/14 1250hrs  calls           | 04/01/14 1300hrs  sms            | 08/01/14 1301hrs  calls          | 08/01/14 1330hrs 

how should create table , use count?which show

-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_  -no. of calls  || no. of sms-  -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_  -4             || 4         -  -_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_ 

i foget add in. lets got user 1, 2 , 3. want search user 1 made how many phone calls , how many sms, user 2 made how many phone calls , how many sms , on. how should write it?

select type, count(*) phone [date/time] between x , y group type