I have an issue which I'm trying to solve. We contact customers a number of times during an application. We don't count how many times we call them. I want to get an SQL statement which this by date.

Attached is an image of how the column should appear, with the inserted column in yellow. Would be amazing to see this statement!

thanks Matt

enter image description here

  • Where is the call information stored? Are your call records stored inside of a separate DE? Jun 7, 2018 at 13:15
  • Two images provided seem to be identical. Am I missing something?
    – Ranga
    Jun 7, 2018 at 13:16
  • @Gortonington all records are in the same table Jun 7, 2018 at 22:53
  • @Ranga, sorry i put in the image twice accidently! Jun 7, 2018 at 22:54
  • 1
    You should be able to do something like: select count(id), Email From ObjectName Group By Email
    – Ranga
    Jun 8, 2018 at 8:18

1 Answer 1


You should be able to do something like:

[select count(Id), Email From ObjectName Group By Email]

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .