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
harina [27]
4 years ago
14

Write an SQL statement that uses all of the SQL built-in functions on the Quantity-OnHand column. Include meaningful column name

s in the result.
Computers and Technology
1 answer:
Alexxx [7]4 years ago
8 0

Answer:

Query:

select sum(QuantityOnHand) as "Total Quantity",  count(QuantityOnHand) as "Total Quantity column",  avg(QuantityOnHand) as "Average Quantity",  max(QuantityOnHand) as "Maximum Quantity", min(QuantityOnHand) as "Minimum Quantity" from inventory ;

Explanation:

The above SQL query holds all the SQL built-in functions. This type of function calculates the results like mathematics functions. There are 5 functions of these types which are as follows:-

  1. sum function is used to calculate the sum.
  2. count function is used to count the number of rows.
  3. min function is used to find the minimum value.
  4. max function is used to find the maximum value.
  5. avg function is used to find the average of the number.

The above query also holds the as a keyword which is used to display the duplicate column name in the place of the original column name.

You might be interested in
15. Cinematic tutorials and action-movie camera shots mixed with gameplay and some of the features that have made _____ stand th
Salsk061 [2.6K]
It’s C: The last of us
7 0
3 years ago
What are the tiny little dots that make up a digital photograph?
postnew [5]
My answer -

They are called pixels you can tell the size of a digital image by using pixels.

P.S

Happy to help you have an AWESOME!!! day XD
8 0
4 years ago
Read 2 more answers
Write a function isRed() that accepts a string parameter and looks for the presence of the word ‘red’ in the string. If it is fo
Ilia_Sergeevich [38]

Answer:

Using the Python Programming Language:

def isRed(myString):

   if "red" in myString:

       return True

   else:

       return False

Explanation:

The function definition is given above. To output the result of calling this function, we declare a string variable and call the function inside a print statement. See the two lines of code below:

myString= "My house is coloured red"

print (isRed(myString))

Notice that we defined the function called isRed to receive a string as a parameter, Then using the in keyword with an if statement, we check for the presence of the word 'red' in the string that is passed as argument to the function, the function will then return True if the word 'red' is present or False if it is not.

7 0
3 years ago
Read 2 more answers
A network supplies programming and services to a series of local tv stations, or _____, which contract to preempt time during sp
solong [7]
It is the Affiliates. The vast majority of which are autonomously claimed, legally consent to acquire time amid determined hours for programming gave by the systems and to convey the national promoting inside the program. 
It enables site to all the more effortlessly find and take an interest in subsidiary projects which are reasonable for their site and permits sites offering member projects to contact a bigger crowd by advancing their partner programs.
6 0
4 years ago
Renee's creating a plan for her business's information system. What should she do after she determines the goals for her busines
stiks02 [169]

get organized because of the beging when she start she will want ot be nice and fresh on everything

7 0
4 years ago
Other questions:
  • A custom date format set for a date/time field that contains the symbols mmm/dd/yy would display the date as ____.
    12·1 answer
  • In a series circuit, electrons only flow along one path. Given this information, which of the following is an advantage of serie
    15·2 answers
  • 7. Which innovation in video games do you think has been most significant? Include at least one way that innovation affects the
    6·1 answer
  • What is the decimal equivalent of the largest binary integer that can be obtained with
    9·1 answer
  • As the demand for goods and services decreases, job growth.
    14·2 answers
  • Given the integer variables x, y, and z, write a fragment of code that assigns the smallest of x, y, and z to another integer va
    7·1 answer
  • The smallest unit of storage is​
    15·1 answer
  • What does the action tool allow you to do in Microsoft Powerpoint?
    15·1 answer
  • Sort the layout options for two types of masters in PowerPoint.
    5·1 answer
  • Does anyone know how to permanently delete photos on a dell computer? For my cousin.
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!