when s.total_demand > 10 then p.base_price * 1.1 when s.total_demand < 5 then p.base_price * 0.9 ...