-- 1
SELECT name FROM `product`

name
Mother Board
KEY Board
Hard Drive
Mouse
Processor
DVD drive
CD drive
Monitor
Printer
Speaker


-- 2
SELECT name FROM `product` WHERE price <= 200

name
KEY Board
Hard Drive
Mouse
DVD drive
CD drive
Speaker

-- 3
SELECT * FROM `product` WHERE price >=40 AND price <= 110

_id NAME    price
2   KEY Board   60
4   Mouse   40
7   CD drive    110

-- 4
SELECT AVG(price) FROM `product`

197.0000

-- 5
SELECT COUNT(_id) FROM `product` WHERE price >=250

4


-- 6
SELECT name, price FROM `product` WHERE price >= 150
ORDER BY price DESC, name ASC

name    price
Printer 450
Monitor 320
Mother Board    280
Processor   260
Hard Drive  180
DVD drive   150

-- 7
UPDATE product SET name = 'DVD RW' WHERE _id = 6

RESULT:
SELECT * FROM `product` WHERE _id = 6

6   DVD RW  150

-- 8
UPDATE product SET price = price * 0.88 WHERE price >= 150

SELECT * FROM `product` WHERE 1

_id NAME    price
1   Mother Board    246
2   KEY Board   60
3   Hard Drive  158
4   Mouse   40
5   Processor   229
6   DVD RW  132
7   CD drive    110
8   Monitor 282
9   Printer 396
10  Speaker 120