view avg_pri.txt

来自「这是jsp与数据库开发的源代码 全部都在这里了」· 文本 代码 · 共 6 行

CREATE view avg_pri
AS
SELECT type AS type,avg(price) AS a_price 
FROM titles
GROUP BY type