Hail, Stack!
I need to select the count of values grouped by ranges.
To exemplify, suppose that I have the following values in a table columm: 1,2,4,5,6,8,9,11,13,16
Then, I want to retreave the count of them in ranges of 5, like this:
From 0 to 4 there is 3 values (1,2,4)
From 5 to 9 there is 4 values (5,6,8,9)
From 10 to 14 there is 2 values (11,13)
From 15 to 19 there is 1 values (16)
And so on...
How can I make this in a query?