1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
lyudmila [28]
3 years ago
9

Write a SQL statement to display the SKU, Description, for all products that have a QuantityOnHand value equal to 0 and a Quanti

tyOnOrder value greater than 0. Explain what useful information this statement provides for the business.
Computers and Technology
1 answer:
9966 [12]3 years ago
4 0

Answer:

SELECT SKU, SKU_Description

FROM INVENTORY

WHERE QuantityOnHand =0

AND QuantityOnOrder > 0;

Explanation:

Here SELECT statement is used to select SKU and SKU_Description from Inventory table. WHERE clause is basically used to check a condition. Those records are selected from the Inventory table in which the QuantityOnHand is equal to 0 and QuantityOnOrder is greater than 0. AND here is used to specify that both the conditions QuantityOnHand =0  and QuantityOnOrder > 0 should hold.

SKU stands for stock keeping unit which is used to track the Inventory and to search stock from the database or tables.  QuantityOnHand is basically the total number of available items except for the items that are already taken for the sale order and QuantityOnOrder is how many items ordered from the supplier. This will help to provide information about which items are not in the warehouse currently and knowing quantity on order is important for business to so that the duplicate orders of same items can be avoided.

You might be interested in
Which of the following calculations would evaluate to 12?
lidiya [134]

Answer:

the answer for this is 3*(6+2)/2)

8 0
3 years ago
When C++ is working with an operator, it strives to convert operands to the same type. This is known as
ziro4ka [17]

Answer:

The answer is "Option B"

Explanation:

Conversion of type is a way of changing an entity from one data type to another. It is used to make the variable process properly by a function in computer coding.  

In the C++ language, the result of the multitype value added or any other option is the result between those variables as a large type at that time, that's why choice b is correct.

7 0
3 years ago
Jargon is:
pentagon [3]

Answer: The answer would be "B" - language that includes terms that only a select few can understand

Explanation:

3 0
3 years ago
Read 2 more answers
What should you do if your temperature gauge moves up to just below the red zone?
Alexeev081 [22]
<span>If the temperature gauge moves up to just below the red zone,you should turn off your air conditioner and turn on your vehicle's heater. Then immediately </span>find a mechanic or pull over safely and contact a road service.




4 0
3 years ago
Read 2 more answers
Choose the list of the best uses for word processing software.
Marina86 [1]
List, resumes, spread sheet, databases, contracts
4 0
4 years ago
Other questions:
  • Unix has experimented with several security programs. a user can attach a watchdog program to a file that grants or denies acces
    13·1 answer
  • Jeffrey works with a huge database of spreadsheet records each day. To organize and identify these spreadsheets, he wants to ass
    8·1 answer
  • Which are types of online resources that students can use for help? Check all that apply. simulated labs web-based educational g
    12·2 answers
  • Create a function named first_a that uses a list comprehension. The function will take a single integer parameter n. Find every
    13·1 answer
  • Which of the following types of cloud platforms would a webmail service offered to the general public be considered?
    9·1 answer
  • I need help!
    14·1 answer
  • Fill in the blank; "As well as their traditional role of computing data, computers are also extensively used for..."
    14·1 answer
  • Microsoft <br> Excel Module 6
    11·1 answer
  • Primary technology skills are skills that are necessary for success in online education
    9·2 answers
  • In Subtractive empathy, the counselor responses gives back less (or distorts) than what the client has said. slightly add someth
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!