hi

the below code may helpful

select distinct column1,AVG(column2) maridain

from table

group by column1