sql问题,查询重复数据

SELECT

  from_address as address,

  (value)/1000000000000000000 as balance

FROM `xxxx` AS contracts

JOIN `xxxx` AS transactions ON (transactions.to_address = contracts.address)

WHERE to_address = 'xxxxx'

1.如果address 重复则累计增加 balance 的数据，并去除重复的address 

2.去除balance为0的行 

3.筛选balance范围为 1-10的数据统一更新为 30