SESSION NAME: SQL Functions - 1.

QUESTION NAME: Maximum of Items ordered.


TABLE DESCRIPTION:
Write a query that prints the maximum of customerid, quantity and price in items_ordered table.

Note: Use SQL in-built Function to calculate maximum of the tuples in items_ordered table.

The statement has to return a single result which contains the maximum value of customerid, quantity and price columns of everything returned in the items_ordered table.

CODE:
select max(customerid), max(quantity), max(price) from items_ordered ;