1.SELECT Count(*) FROM Products WHERE CategoryID=2
2.SELECT Count(*) FROM Products WHERE UnitPrice BETWEEN 20 AND 35
3.SELECT MIN(UnitPrice) FROM Products WHERE CategoryID=3
4.SELECT MAX(UnitPrice) FROM Products WHERE CategoryID=4
5.SELECT AVG(UnitPrice) FROM Products WHERE CategoryID=4 or 5
6.SELECT ShipCity,Count(ShipCity) FROM Orders Group By ShipCity
7.SELECT ShipCountry,ShipCity,Count(ShipCity) FROM Orders Group By ShipCountry, ShipCity
8.SELECT MIN(UnitPrice),MAX(UnitPrice),AVG(UnitPrice) FROM Products Group By CategoryID
9.SELECT count(*) FROM orders WHERE Orderdate Between '1996-01-01 00:00:00' AND '1996-12-31 23:59:59'