UPDATE products
SET price = CASE
    WHEN category = 'Electronics' THEN price * 1.10
    WHEN category = 'Books' THEN price * 1.05
    ELSE price
END,
updated_at = CURRENT_TIMESTAMP
WHERE stock_quantity > 0;