Answer: Google doesn't have the answer.
Explanation:
I tried
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
In the given question table -name is "COMPANY" the condition is on the sales column and it update the table only when sales is more than 20000 and set the column COMM by 500.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
what is the usage of sustainable energy?
Does white space have visual weight? Yes or No
Answer:
no. (more info below)
Explanation:
white space appears to have no visual weight because it's seen as empty. Every body put in the room will appear to be heavier because of the volume surrounding it.
hope this helped!
Answer:
no
Explanation:
it's because it appears to be empty.