beecrowd SQL | 2610

Average Value of Products

Paulo R. Rodegheri BR Brasil

Timelimit: 1

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