10. 查询小米Note2共有几次订单，显示产品名称，订单数量

SELECT
	pname,
	COUNT(pname)
FROM
	product,
	orders
WHERE
	product.pid = orders.pid
AND product.pname = '小米Note2';