left join解法

select
  cust_id,
  sum(item_price * quantity) total_ordered
from
  Orders
  left join OrderItems using(order_num)
group by
  cust_id
order by
  total_ordered desc;