Question

How would you update the status column of the orders table to set all orders with a total amount greater than 1,000 to High Value?

Answer 1

UPDATE orders

SET status = 'High Value'

WHERE total_amount > 1000;