Summing the results of Case queries in SQL
- by David Stelfox
I think this is a relatively straightforward question but I have spent the afternoon looking for an answer and cannot yet find it. So...
I have a view with a country column and a number column. I want to make any number less than 10 'other' and then sum the 'other's into one value.
For example,
AR 10
AT 7
AU 11
BB 2
BE 23
BY 1
CL 2
I…