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:
Green computing is also known as green information technology (green IT)
Answer:
The code to calculate the area of a circle is:
from math import pi
def circleArea(radius):
if radius > 0:
return pi * (radius ** 2)
else:
return None
if __name__ == '__main__':
radius = 5
print("Radius: {} Area: {}".format(radius,circleArea(radius)))
Explanation:
A detailed explanation of each line of code is given below.
#Define the number pi used to calculate the area
from math import pi
#We define a function that calculates the area of a circle
def circleArea(radius):
#Check if the radius is valid ( radius > 0) since there aren´t negative radius
if radius > 0:
#Compute the area formula for a circle 
return pi * (radius ** 2)
else:
#Return None if the radius is invalid
return None
#Run the function we´ve defined
if __name__ == '__main__':
#Define a radius
radius = 5
#Call the function and parse the radius through it, then print the result
print("Radius: {} Area: {}".format(radius,circleArea(radius)))
Answer:
step 1:- start
step 2:-read principal amount, rate and time
step 3:- calculate interest using formula sI=((amount*rate*time)/100)
step 4:- print simple interest
step 5:- //CPP program to find compound interest for. //given values
Answer: OS(Operating System), CPU, And The Program That you use to view email