Question

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

Answer 1

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.