--sort all items with color=red by desc order
SELECT * FROM `products` WHERE `color`='red'
ORDER BY `price` DESC

--find all purchases between 400-500
SELECT * FROM `purchases` WHERE `purchase_amount` BETWEEN 400 AND 500;

--find all purchases by yehuda or yevgenni
SELECT * FROM `purchases` WHERE `name`='yevgenni' OR `name`='yehuda'