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 20000. The table’s name is COMPANY?

Answer:

UPDATE COMPANY

SET COMM=COMM + 500

WHERE SALES> 20000;

Explanation:

The update command is used for alter the record in the database management system in the table .The update command command modify the record on the some condition in the table in the database management system.

Following are syntax for using the update command .

UPDATE table-name

SET column name 1,column name 2 .........

Where condition

The UPDATE command that increases the commission column is: UPDATE COMPANY  SET COMM=COMM + 500  WHERE SALES> 20000;

The syntax of an UPDATE SQL command is:

UPDATE table_name SET column = value, where condition

From the question, the table name is COMPANY.

So, we have:

UPDATE COMPANY SET column = value, where condition

The update statement is to increment the COMM column by 500.

So, the query becomes

UPDATE COMPANY  SET COMM=COMM + 500  WHERE condition

Lastly, only columns where SALES are greater than 20000 should be updated.

So, the complete command is:

UPDATE COMPANY  SET COMM=COMM + 500  WHERE SALES> 20000;

Read more about database at:

https://brainly.com/question/15334693