SELECT cust_id, sum(item_price*quantity) as total_ordered
FROM OrderItems O
RIGHT JOIN Orders O2 on O.order_num = O2.order_num
GROUP BY cust_id
ORDER BY total_ordered desc