这是您想要的吗?

select column1, avg(column2) from table group by column1