How to lower the price of a product?

Question

MySQL

The task is this. You need to select all the data from the cars table that are in the range from 100000 to 200000 and reduce the price for all of them by 3000. Tell me what you need to add to the query?

$UpdateInsert = execQuery('UPDATE cars SET cost = 3000 FROM cars WHERE cost BETWEEN 100000 AND 200000;');

Answer 1

update cars set cars.cost = (cars.cost - 3000) where cars.cost between 100000 and 200000;