i have interest rate and amount in a table where interest rate are ranged in different values
like 4.5,4.6,5.2,5.6 etc.
i want to get sum of amounts classified by interest rate where interest rate will be separated
by .25.
for example all amount having interest rate 1.25,1.3,1.4 will be in one group
and 1.5,1.67,1.9 will be in another group
how can i write the query?