I'm new to SQL and sorry if this q has been asked before - I couldn't phrase it properly.
Say I have a table that looks like this:
Name Call ID
Name No. of calls
COUNT(distinct Name) AS No. of Calls
You just need to group them and that's all.
SELECT Name COUNT(*) AS [No. of Calls] FROM Table GROUP BY Name