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