Uri - Beecrowd | 2608 | Higher and Lower Price

 | 2608

Higher and Lower Price

Paulo R. Rodegheri  Brazil

The financial sector of our company, wants to know the smaller and higher values of the products, which we sell.

For this you must display only the highest and lowest price of the products table.

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	price
800	25.50

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

  URI - BEECROWD Online Judge 2608 Solve in SQL:                                          

-- Solved by Intesar
SELECT MAX(price),MIN(price)
FROM products;