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.
Answer:
For setting up workstations in classrooms, one end of cables connected into the built in NIC and other end will be connected to a drop.
Explanation:
A drop will be used for connectivity in this case, which will work as connection point in a network. Drops are just like outlets in wall having Ethernet Jacks where a network device or system can be plugged into it.
Answer:
888 + 88 + 8 + 8 + 8 = 1000
Explanation:
Required
Add up to 1000 using only digit 8
There is no straight way to answer this question; so, we make use of trial by error method to arrive at our solution.
After several trials, I found out that:
888 + 88 + 8 + 8 + 8 = 1000
This is for Python
number = int(input('Number: '))
number = number * 12
print(number)
