Uri - Beecrowd | 2610 | Average Value of Products

 | 2610

Average Value of Products

Paulo R. Rodegheri  Brazil

In the company that you work is being done a survey on the values of the products that are marketed.

To help the industry that is doing this survey you should calculate and display the average value of the price of the products.

OBS: Show the value with two numbers after the period.

Schema

products

Column	Type
id (PK)	numeric
name	varchar
amount	numeric
price	numeric

Tables

products

id	name	amount	price
1	Two-doors wardrobe	100	800
2	Dining table	1000	560
3	Towel holder	10000	25.50
4	Computer desk	350	320.50
5	Chair	3000	210.64
6	Single bed	750	460

Output Sample

price

396.10

N.B.: It's better if you solve this by your own. Thank you!

  URI - BEECROWD Online Judge 2610 Solve in SQL:                                          

-- Solved by Intesar
SELECT ROUND(avg(price),2) as price
from products;