23.sql

机械工业出版社《SQL Server应用开发实例教程》源代码

select gpyy as 语言,avg(gpdj) 
as 平均价格,sum(gpdj*qnt)
as 光盘总价
from gpb
group by gpyy