Flexible Interval Aggregation — From SQL to SPL #5

Problem description & analysis: The range of the ID field in a table of Oracle database is integers 1–2000. Task: Now we need to group IDs into multiple consecutive intervals, sum up the values within each group, and arrange the calculation results ...