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.

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:-

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.

answera hit;