Uri - Beecrowd | 2604 | Under 10 or Greater Than 100

 | 2604

Under 10 or Greater Than 100

Paulo R. Rodegheri  Brazil

The financial sector of the company needs a report that shows the ID and the name of the products whose price is less than 10 or greater than 100.

Schema

products

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

Tables

products

id	name	amount	price
1	Two-door wardrobe	100	80
2	Dining table	1000	560
3	Towel holder	10000	5.50
4	Computer desk	350	100
5	Chair	3000	210.64
6	Single bed	750	99

Output Sample

id	name
2	Dining table
3	Towel holder
5	Chair

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

  URI - BEECROWD Online Judge 2604 Solve in SQL:                                          

-- Solved by Intesar
SELECT id,name
FROM products
WHERE price < 10 OR price > 100;