Write the UPDATE command to increase the commission (Column name : COMM) by 500 of all the Salesmen who have achieved Sales (Column name : SALES) more than 200000. The table's name is COMPANY.
Answer
UPDATE COMPANY
SET COMM = COMM +500WHERE SALES >200000;
