怎么对一个嵌套查询的结果求和

Question

怎么对下面的语句的money进行sum求和
select money from details where id in (select id from goods where name = ‘%自行车%’)
子查询结果是个集合

Answer 1

select sum(money) from details where id in (select id from goods where name ='%自行车%')

有帮助的话，请点采纳该答案~