5. 创建视图vw_vp：查询小米Note2的供应商姓名（vname）、供应商地址（vaddress）、邮政编码（vzip）,产品价格（pprice）。

CREATE VIEW vw_vp AS SELECT
	vname,
	vaddress,
	vzip,
	pprice
FROM
	vendor,
	recruit,
	product
WHERE
	vendor.vid = recruit.vid
AND product.pid = recruit.pid
AND product.pname = '小米Note2'
GROUP BY
	vname