Sum sql query

Hi,

I have a table with data looking as below:
Design of tableTable result
I would like to sum the different events so the result will be like this:
Event                Quantity
Processed        4
Delivered         4
Open                6
Click                 3

How should my query look like to make this happen?

Thanks for help!

Peter
peternordbergAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ReneD100Connect With a Mentor Commented:
SELECT event, Count(event) AS Qty
FROM cgms
GROUP BY event;

Open in new window

0
 
Haris DjulicConnect With a Mentor Commented:
use this:

select event, count(*)
from customerGruopmailstatistics
group by event

Open in new window

0
All Courses

From novice to tech pro — start learning today.