sql怎么通过写语句实现上图的转变,或者可以说一下解答思路,谢谢了
select name,id,sum(price) from table group by name,id having sum(price) >0