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
select count(id), Email From ObjectName Group By Email