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