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?

Answers

Answer 1

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 2

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


Related Questions

What are the three types of secondary storage?

Answers

Answer:

we have the; Solid state storage device e.g USB memory, optical storage device e.g CD, DVD and Blu-ray discs And the Magnetic storage device e.g hard disk drive

what type of data can be entered into a electronic spreadsheet

Answers

Answer:  Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.

Values (numbers) are generally raw numbers or dates.

Explanation: Google.!

A mechanic uses a screw driver to install a ¼-20 UNC bolt into a mechanical brace. What is the mechanical advantage of the system? What is the resistance force if the effort force is 5 lb.

Answers

Answer:

15.7 ; 78.5

Explanation:

Mechanical advantage of a screw = Circumference / pitch

Circumference = pi × d

Where :

pi = 3.142, D = diameter

Therefore ;

Circumference = 3.142 × (1/4) = 0.785 in

Pitch = 1/TPI

TPI (thread per inch) = 20

Pitch = 1/ 20 = 0.05

Mechanical advantage = 0.785 / 0.05 = 15.7

Resistance force if effort force is 5lb

Mechanical advantage = Fr / Fe

Fe = effort force, Fr = resistance force

15.7 = Fr / 5

Fr = 15.7 × 5 = 78.5 lbs

how does a computer work

Answers

Answer:

computer works on electricity

Explanation:

30 POINTS!!

Drag the tiles to the correct boxes to complete the pairs.
Match each design principle with its description.

Answers

Answer:

1. dominance

2. proportion

3. contrast

4. unity

5. gradation

Answer:

s

Explanation:

features of action files​

Answers

Answer and explanation:

An ".action" file is a file written in Xcode and used by the Automator program, whose function is to create automations in macOS.  Action files contains specific actions that can be combined with other actions to create an automated process.

This type of file is used to automate tasks in macOS, usually with Finder (file manager) or another program.  

Action files are especially useful for repetitive tasks, such as creating sequential batch folders, editing images, or deleting files.

every input/output of a computer is effectively a type of?

Answers

Answer:

I think the answer will be information

Give two reasons why mobile internet may not be available everywhere. ​

Answers

Answer:

Mobile Internet is dependant on cellular signal. Many countries, e.g. in Africa, don't have any coverage at all. Furthermore, mobile data might also not be available in the mountains as there are no cell towers and the rough terrain usually either blocks the signal entirely or weakens it significantly.

The term citizenship means that citizens in a country:
A. are required to vote in every national election.
B. have certain rights, duties, and responsibilities.
c. must complete the naturalization process.
D. have to have been born in the country.

Answers

Answer:

Its B.

Explanation:

I think

Answer:

B: Have certain rights, duties, and responsibilities.

Explanation:

I got it right.

30 POINTS!!

Type the correct answer in each box. Spell all words correctly.

How are paragraphs distinguished in a website?

Paragraphs are separated using two styles: by ____ or by a ____ line space.

Answers

Answer:

paragraph or by a break line space

Answer:

Paragraphs are separated using two styles: by indentation or by a blank line space.

Explanation:

trust me

Using substitution what is the value for x for the equations 2x+y=-3 and
y=4x+6? *
X3
x=3/2
O
x=0​

Answers

Answer: x = -3/2

Explanation:

Hi, to answer this question we have to solve the system of equations:

2x +y =-3

y=4x+6

Substituting y=4x+6 in the first equation:

2x + (4x+6) =-3

Solving for x:

2x +4x+6 =-3

2x+4x =-3-6

6x =-9

x =-9/6

x = -3/2

In conclusión, the value of x is -3/2.

Feel free to ask for more if needed or if you did not understand something.  

Darla is going to start writing the HTML code for a web page. What would she
start with?
A. Header
B. Closing tag
C. Opening tag
D. Title

Answers

Answer:

(C) Opening Tag

Explanation:

HTML code is contained in an opening and closing tag. To start writing code you need to first type in the opening tag.

Darla can be able to start with Opening tag. Check more about HTML code below.

What are tags in HTML?

An HTML tag is known to be a part of made up language that is often used to show the start and also the ending of an HTML element that can be found in any  HTML document.

Conclusively, for Darla to be able to start writing the HTML code for a web page, she needs an Opening tag for it to start.

Learn more about HTML code from

https://brainly.com/question/24051890

#SPJ5

Select the correct answer.

Florence is switching jobs. Her previous company worked on Java. The new company works on .NET. Which educational option can help Florence cope with the new programming language at the new job?

A. bachelor’s degree

B. high school degree

C. external training

D. masters degree

Answers

Answer:

I GO FOR OPTION D

Explanation:

BECAUSE THE OPPORTUNITIES ARE MORE FOR MASTER DEGREE THAN COMPARED TO OTHERS..AND EASY TO GET A JOB ACCORDING TO ME..AND MASTER DEGREE AT HIGH LEVEL UNIVERSITY MAKES MORE EASY TO GET A JOB..

HOPE YOU LIKE THAT

Name atleast two advantages of using models in science

Answers

When students are engaged in scientific modeling, they are able to notice patterns and develop and revise representations that become useful models to predict and explain, making their own scientific knowledge stronger, helping them to think critically, and helping them know more about the nature of science.

In one to three sentences, describe how a digital ink pen could make a task more efficient.

Answers

Answer:

First, digital ink pens will never run out of ink as they do not use ink at all for writing, making it more efficient for the writer to right for longer periods of time. Second, digital ink pens can be used to take notes on any device such as cell phones, tablets, etc.

Explanation:

Who developed the first commercially
successful DBMS called Information
Management system.

Answers

Charles Bacheman invented the DBMS

What does choosing Slide Sorter view do?
Select the correct answer.
X
fills the entire computer screen with a slide
allows you to select slide layouts
displays miniature versions of all the
presentation's slides​

Answers

Answer:

The last two line i.e "displays miniature versions of all the  presentation's slides​  " is the correct answer to the given question .

Explanation:

The main objective of the slide sorter is showing the miniature versions of all the slides though user can quickly push the slides and organize the slides in well mannered by moving the slides . The Slide Sorter display gave the viewers to thumbnail the overview of the slides.

The slide sorter making the presentation effective by organizing and sorting the slide .All the other option are not correct for the  Slide Sorter view that's why these are incorrect option .

Which increases the rate of soil formation?

Answers

Answer: Increased temperature increases the rate of chemical reactions, which also increases soil formation. In warmer regions, plants and bacteria grow faster, which helps to weather material and produce soils. In tropical regions, where temperature and precipitation are consistently high, thick soils form.

Explanation: Hope this works

They are created from rocks (the parent material) by weathering and erosive forces of nature. Parent material is broken down by a variety of factors, including water, wind, gravity, temperature change, chemical reactions, living things, and pressure variations.

What are the factor involving in the formation of soil?

Parent materials' rate of weathering and, consequently, soil characteristics like mineral composition and organic matter concentration are influenced by temperature and precipitation.

Faster plant and bacterial growth in warmer climates aids in the weathering of materials and the formation of soils. Thick soils develop in tropical areas where the temperature and precipitation are both constantly high.

Therefore, The rate of chemical reactions is accelerated by rising temperature, which also accelerates soil formation.

Learn more about soil formation here:

https://brainly.com/question/19554237

#SPJ2

What does tone of voice communicate?
O A. The sentence structure of a discussion
B. Nuances in meaning, including emotions
C. The time of day when people are talking to one another
D. Intentions expected from the audience

Answers

i’m pretty sure it’s B?

Answer:

B. Nuances in meaning, including emotions

Explanation:

Need help with this programming question plz!

Answers

Answer:

d. X ==2

Explanation:

It is a Boolean Expression so == means equal to.

I had to review my Relational Operators/ Conditional Operators, lol.

Write code using the range function to add up the series 99, 98, 97,...
1 and print the resulting sum.
Expected Output
4950

Answers

Answer:

This program is written in python;

Comments are used for explanatory purpose;

Take note of indentations (See picure attachment)

Program starts here

#Initialize Sum to 0

sum = 0

#Iterate from 99 to 1 using range function

#The iterating variable i starts from 99 and ends at 1 with a difference of -1

for i in range(99, 1, -1):

sum+=i

#Display Result

print("Expected Output: ",sum)

#End of Program

In 1838 after pressuring the Cherokee to sign treaties giving up their lands, the federal government
forced Cherokee resistors to adopt the lifestyle of white settlers.
O realized that it could not legally take land from unwilling Cherokee
O sent the US Army to force Cherokee resistors to march west.
filed a lawsuit against the Cherokee Nation to force its removal​

Answers

The correct answer is C. Sent the US Army to force Cherokee resistors to march west.

Explanation:

In 1835 the U.S. government persuaded traditional Indian tribes including the Cherokee to sign a treaty that established the Cherokee would leave their land in exchange for money and other benefits. This treaty was signed by those that represented a minority in the tribe, and therefore it did not represent the opinion of all the tribe.

Additionally, after this treaty the government made the Cherokees leave their land and move to the Indian territory in the West. This was possible because the government sent the US Army, also, this forced displacement had a great negative effect in the tribe not only because they had to leave their land, but also because many died in the process.

Answer:

its C

Explanation:

I got 100 on my Quiz

What are examples of intermediate goals that require funding? Check all that apply.

1.) applying to college
2.) attending college
3.) interviewing for a job
4.) getting a summer job
5.) getting a promotion
6.) taking a licensing exam

Answers

Answer:

The answer is 1,2,6

Explanation:

The examples of intermediate goals that require funding are applying to college and attending college. Thus, option A and B are correct.

Which careers require college degree?

Some careers in the financial services sector require a college degree and others require a specialized license. Those requiring a unique license are banking and accounting.

A bank is an institution that deals in money and its substitutes and provides other money-related services. In its role as a financial intermediary, a bank accepts deposits and makes loans. Many banks provide related services such as financial management and products such as mutual funds and credit cards. For career in a banking field, a persons require specialized license.

Therefore, The examples of intermediate goals that require funding are applying to college and attending college. Thus, option A and B are correct.

Learn more about bank here:

brainly.com/question/29797792

#SPJ5

When checking for a no-start concern, you notice that an engine has no spark. Technician A says to turn on the ignition (engine off) and, using a DMM, find out how much battery voltage is available at the negative terminal of the ignition coil. Technician B says the DMM reading should fluctuate, indicating that the primary coil current is being turned on and off. Who is correct?


A. Neither Technician A nor B

B. Both Technicians A and B

C. Technician B

D. Technician A

Answers

Answer:

Option(C) is the correct answer to the given question.

Explanation:

Since overall the On-Board Diagnostics of the level 2 the computer systems need to evaluate the cause of the engine failures .The malfunction significantly increases in the fuel consumption, so that we can detecting the error code in the vehicle.

If we starting the engine as well as by using the DMM, we'll  see how much battery voltage it is at the negative ignition coil node.If the spark module is faulty and no ignition coils can fire so all the engines are working that's why all the other option are incorrect .

This is a python program my teacher assigned:
Create a list of days of the week. (yes, this uses strings)
A) Print each day using a for loop.
B) for non-school days, print “freedom” next to the day of the week.

How would I execute this?

Answers

Answer:

#Create an array for week

week = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday","Sunday"]

#Create a varable index and use index to loop through week(array)

for index in week:

 #if the index is on Saturady or Sunday then, print freedom

 if index == "Saturday" or index == "Sunday":

   print(index + " Freedom")

#else just pint out the other days

 else:

   print(index)

Always accept a job offer before discussing its salary and benefits.


Please select the best answer from the choices provided

Answers

This question is incomplete because the options are missing; here is the complete question

Always accept a job offer before discussing its salary and benefits.

Please select the best answer from the choices provided:

True

False

The correct answer to this question is False

Explanation:

Salary and benefits are considered to be the way you are paid for your job and the time you spent on it. Also, salary might vary depending on the complexity of the job, possible risk, knowledge or preparation required, among others. Because of this, the salary and benefits must adjust to the type of job, time, effort, risks, among others. Thus, you should never accept a job before discussing its salary and benefits as you might end being underpaid or you might not receive enough benefits or compensation for the job, which will lead to dissatisfaction.

Answer:

false !!

Explanation:

What are the
advontages of social medio?​

Answers

Answer: some advantages are making sure you’re informed about things going on in the world and connecting with you’re friends or even talking to family members. I hope this answered you’re question!

Explanation:

what type of data can we enter in a spreadsheet?

Answers

Answer:

Spreadsheet data is information that is stored in any spreadsheet program such as Excel or Google Sheets. Data stored in cells in a worksheet can be used in calculations, displayed in graphs, or sorted and filtered to find specific information. hope that helps love!

In a spreadsheet, we can enter numbers, text, dates and times, formulas and functions, Boolean values, currency and financial data, hyperlinks, and images/objects

Numbers: This includes whole numbers (integers) and numbers with decimal points (floating point numbers). Spreadsheets typically support mathematical calculations and formulas involving numeric data.

Text: You can enter plain text, such as names, descriptions, labels, or any other textual information.

Dates and Times: Spreadsheets often provide specific formatting options for entering and manipulating dates and times.

Formulas and Functions: Spreadsheets allow you to enter formulas and functions that perform calculations or manipulate data based on specified rules.

Boolean Values: Spreadsheets often support Boolean values (true/false) for logical operations and conditional formatting.

Currency and Financial Data: Spreadsheets often provide formatting options and built-in functions for dealing with currency and financial calculations.

Hyperlinks: You can insert hyperlinks in spreadsheets to link to external resources or other cells within the spreadsheet.

Images and Objects: Depending on the spreadsheet software, you may be able to insert images, charts, graphs, and other objects to enhance the visual representation of your data.

To learn more on Spreadsheet click:

https://brainly.com/question/10509036

#SPJ6



1-the principle of recycling applies only to open systems

True/False


2-It is important that measurements be consistent in engineering because

A-There is only one established system of measurement available

B-there is one unit that is used to measure weight, length and distance

C-engineers often work together internationally and replicate each others' results


Answers

Answer:

The answer to this question can be described as follows:

In question 1, the answer is False.

In question 2, Option C is correct.

Explanation:

Recycling seems to be the concept of organizing life by making use of as little resources as possible. The recycling approach enables us to live and reconstruct in modules that are closed, it use everywhere not only in the open system. Measurements must be accurate in engineering because engineers often operate independently globally and repeat the findings of one another.

what is the purpose of document inspector​

Answers

Answer:

to remove any metadata that should be private

Explanation:

Got it right on edg.

Other Questions
An assault on system security that derives from an intelligent act that is a deliberate attempt to evade security services and violate the security policy of a system is a(n) _________.A. RiskB. AttackC. AssetD. Vulnerability During World War II, which battle denied the Japanese the opportunity to attack Australia?Battle of the Coral SeaBattle of MidwayBattle of GuadalcanalBattle of Iwo Jima Explain phloem structure and function, using the following terms: sieve elements, sieve cells, companion cells, girdling, translocation, sieve areas, P-proteins, non-reducing sugars. How many moles of gas are contained in 22.41 liters at 101.325 kPa and 0C? (Note: use Ideal Gas Law, PV = nRT) a 2.5 mole b 1.5 mole c 1.0 mole d 2.0 mole Complete the stroy please At which point does warm air begin to rise before colliding with cold air? Fashion designers use a croquis to: *a. Sketch the garment and figureb. Design the patternc. Cut swatchesd. Finalize details Quinn used a scale drawing to build a soccer field near his school. Initially, he wanted the field to be 28 yards long and 17.5 yards wide. He decided to change the length of the field to 36 yards.If the width is to be changed by the same scale factor, what is the new width of the field? Express your answer to the nearest tenth.18.522.525.557.6 Which is equivalent to 8+38x-y+3x? 12? Select three options.Which phrases can be represented by the algebraic expressionW12 divided by a numberthe quotient of 12 and a numbera number divided by 12a number divided into 12the product of 12 and a number from this equation, y=12x+1, which of these are true?the slope is 12 the x intercept is 1 the slope is 1 the y intercept is 12 Kansas Enterprises purchased equipment for $76,000 on January 1, 2021. The equipment is expected to have a ten-year service life, with a residual value of $7,200 at the end of ten years. Using the straight-line method, depreciation expense for 2021 would be: Genetic drift and natural selection can both be mechanisms of evolution. However, they are very different mechanisms. Explain how genetic drift is different from natural selectio 4 + 5 /3 squared - 2 squared A company is replacing cables with fiber optic lines in rectangular casing BCDE. If segment DE = 3 cm and segment BE = 3.5 cm, what is the smallest diameter of pipe that will fit the fiber optic line? Round your answer to the nearest hundredth. 3. What is the solution to the equation 3x = 15? Express thesolution as a logarithm, make an estimate, and then evaluate.Round to the nearest thousandth. umm what are the answers for : 21% of 36570 12.2% of 640 87.5% of 860 37.5% of 3200 awwwww pls help meh!!! i need to know asap...please..try help!!...thank u sooo much!!lu yall..pls help!!! A man turns 40 today and wishes to provide supplemental lifetime retirement income of 3,000 at the beginning of each month starting on his 65th birthday. Starting today, he makes monthly contribution of X to a fund for 25 years. The fund earns a nominal rate of 8% compounded monthly. Every 9.65 of lifetime income paid at the beginning of each month starting at age 65 will cost 1,000 to purchase. Calculate x. Hey if you could help me with this it'd mean a lot I can't figure it outL+S=173L+2S=46What is S and what is L? Write a study guide for students who are reading the Declaration of Independence for the firsttime. Assume they are reading this document in English class and already know the basichistorical context. The study guide will have two parts: an introduction that explains howlanguage is used in the text, and 6 to 12 annotations that help your reader to understand andbegin to analyze the document as they read.