M
Mary
I really need help please in writing an SQL Statement. The example below is a
sample of the table I would like the sum of the count of volumes for each
name and the sum of the count of the repeated volumes for each name. The
first two tables are the sample and I will like to create two new tables call
total volumes by names (showing the sum of the count of the volumes per name)
and Total Repeat Volumes by Name (showing the sum of the count of the volumes
of the volumes that are duplicates per reps). I have added the result the
SQL Statement will produce. Any help will be great.
Thanks in advance.
Name Volumes
Mary 111
Tom 121
Tina 123
Mary 111
Tom 121
Tom 131
Name Total Volumes by name Total repeat Volumes by name
Mary 2 2
Tom 3 2
Tina 1 0
sample of the table I would like the sum of the count of volumes for each
name and the sum of the count of the repeated volumes for each name. The
first two tables are the sample and I will like to create two new tables call
total volumes by names (showing the sum of the count of the volumes per name)
and Total Repeat Volumes by Name (showing the sum of the count of the volumes
of the volumes that are duplicates per reps). I have added the result the
SQL Statement will produce. Any help will be great.
Thanks in advance.
Name Volumes
Mary 111
Tom 121
Tina 123
Mary 111
Tom 121
Tom 131
Name Total Volumes by name Total repeat Volumes by name
Mary 2 2
Tom 3 2
Tina 1 0