Respuesta :
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:-
- sum function is used to calculate the sum.
- count function is used to count the number of rows.
- min function is used to find the minimum value.
- max function is used to find the maximum value.
- 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.
