Skip to content
Advertisement

Altering a query to show the overall sum of the numbers combined

I was wondering if there was a way to alter the below query to show the overall results

This is what it currently shows

Is there a way to alter the query to show the sum of just the A, AA, B, Drop, N, NA, NC, and PDROP so when I run the query it will just give me all these status codes added up?

What I would like to show

Total = 1908 The overall sum of these status codes are most important

Advertisement

Answer

something like this :

db<>fiddle here

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement