What is the order priority of the order with the highest total price?
order with the highest total price refers to MAX(o_totalprice);
SELECT o_orderpriority FROM orders WHERE o_totalprice = ( SELECT MAX(o_totalprice) FROM orders )