|< < 45 > >|

Queries

Show amount spent by each customer


select c.name, sum(p.price * i.quantity)
from
    customer c, 
    ord o, 
    item i, 
    product p 
where c.customer_id = o.customer_id 
and   o.ord_id = i.ord_id 
and   i.product_id = p.product_id
group by c.name

|< < 45 > >|