UPDATE products SET price = CASE WHEN category_id = 1 THEN price * 1.10 -- Increase price by 10% for category 1
WHEN category_id = 2 THEN price * 0.95 -- Decrease price by 5% for category 2
ELSE price END, last_updated = CURRENT_TIMESTAMP WHERE is_active = TRUE;