How can a table be compacted by taking the average value for every N records?

Question

SQL

There is a table in which there is a counter with step 1 and a column with numerical values. How can a table be compacted by taking the average value for every N records? That is, from every N consecutive records, make one.

Answer 1

Who cares - you need to group by FLOOR (counter / 5).