view avg_pri.txt

jsp与数据库开发的全部代码

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