使用多个总和优化查询？

我认为家庭是购物者的等级制度。因此，我建议使用

group by

select family_id, shopper_id, product_id,       sum(quantity) as total_quantity_shopper,       sum(sum(quantity)) over (partition by family_id, product_id) as total_quantity_familyfrom productsgroup by family_id, shopper_id, product_id