select cust_id, sum(item_price*quantity) as total_ordered
from OrderItems as a
join Orders as b
on a.order_num=b.order_num
group by cust_id
order by total_ordered desc