select t.id,t.name,t.weight
,sum(t1.count) as total
from goods t 
join trans t1 on t.id=t1.goods_id
where t.weight<50 
group by t.id,t.name,t.weight
having total>20
order by t.id