MySQL查询习题

1）每件商品的单件利润是多少？

SELECT name as 商品名称,inprice*outprice as 商品单价利润 FROM tbl_commodity

2）查询进价大于等于10的商品信息

SELECT NAME
	,
	inprice 
FROM
	tbl_commodity 
WHERE
	inprice > 10 

3）查询进价小于10的商品信息

SELECT NAME
	,
	inprice 
FROM
	tbl_commodity 
WHERE
	inprice < 10

4）查询进价小于10并且商品类型为1的商品信息

SELECT NAME
	,
	inprice,
	type 
FROM
	tbl_commodity 
WHERE
	inprice < 10 
	AND type = 1

5）查询进价小于10或商品类型为1的商品信息

SELECT
	* 
FROM
	tbl_commodity 
WHERE
	inprice < 10 
	OR type = 1

6）查询进价在10-20之间

	SELECT*FROM tbl_commodity WHERE inprice BETWEEN 10 and 20

7）查询商品售价为空的商品信息

SELECT
	* 
FROM
	tbl_commodity 
WHERE
	outprice IS NULL

8）查询商品进价为10或20或30的商品信息

	SELECT name,inprice from tbl_commodity where inprice in (10,20,30)

9）商品名称包括’玩具’的所有商品

SELECT NAME 
FROM
	tbl_commodity 
WHERE
	NAME LIKE '%玩具%'

10）根据商品进价从低到高排序输出

SELECT NAME
	,
	inprice 
FROM
	tbl_commodity 
ORDER BY
	inprice DESC

11）根据商品售价从高到低排序输出

SELECT NAME
	,
	inprice 
FROM
	tbl_commodity 
ORDER BY
	inprice DESC