Question

Considering the following table: Customers Columns: customer_id (number, primary key), name (varchar), country_code (varchar), discount (number) Which statement will increase the discount in 10 for customers who are situated in Germany ('DE - ISO code for Germany)?​

Answer 1

Answer:

Hi there,

I need to run a basic mysql query to increase  the discount by say 10% for the customers who are situated in Germany.

Explanation:

Something like this should work.

UPDATE Customers SET discount = discount*1.1

WHERE country_code = 'DE' ;