Question

Write the UPDATE command to increase the commission (column name :COMM) by 500 of all the salesman who have achieved sales (Column name : SALES) more than 200000. The table’s name is COMPANY.

Answer 1

Answer:

500×200000= 100000000