SELECT Production.price
CASE
WHEN Cost < 1 THEN '2.00'
END
FROM production;
Problem: your syntax (even though you didn't tell us that's the problem).
Like what should it do when when cost >=1 (an ELSE option). It's really quite a mess for so little code - at least in so far as you've given no information about the source of your data. Or even what the problem is (doesn't work isn't helpful)