1571. Warehouse Manager

https://leetcode.com/problems/warehouse-manager/

Account Login - LeetCode

이게 될까 하고 돌렸는데 되네..

select a.name as warehouse_name, sum(a.units*b.volume) as volume
from Warehouse as a
left join (select *, Width*Length*Height as volume from Products) as b
on a.product_id = b.product_id
group by a.name