1-16.sql

该源代码为数据库设计的报刊订阅

select nmno,sum(qty)
from [order]
where term<=12 and term>=1
group by nmno