SESSION NAME: SQL Functions - 1.
QUESTION NAME: Average Function.
TABLE DESCRIPTION:
Write a query that prints the average of the price column.
Note: Use SQL in-built Function to calculate the average
of the price column
The statement has to return a single result which
contains the average value of everything returned in the
price column from the items_ordered table.
Note: Use SQL in-built Function to calculate the average
of the price column
The statement has to return a single result which
contains the average value of everything returned in the
price column from the items_ordered table.
CODE:
select avg(price) from items_ordered;
0 Comments