I'm working with a table named:
dbo_Call_History
Relevant fields are:
'phone' - This is a phone number
'status' - this is a character code examples would be 'PY', 'CN', 'T'
My goal is to group by phone and get a count of each status. I can't quite wrap my head around this. Any help would be appreciated.