SELECT order_id, order_amount, IF(order_amount > 1000, 'High Value', 'Normal Value') AS order_status FROM orders;