23.sql

来自「机械工业出版社《SQL Server应用开发实例教程》源代码」· SQL 代码 · 共 5 行

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