I have this table looking like this:
I would like to count the how many times each event occurs based on each newsletter. So that I get a result like this:
Processed Delivered Open Click Deferred newsletterID
25 22 15 3 3 9
How can I achieve that with an sql query?