计算连续两个月同期销量

[ketty_liang]

我有一个销量表
id date name number
1 11-1 中华 1
2 11-2 摩拉 1
3 11-3 中华 1
......


100 12-20 中华 1
101 12-21 摩拉 1
...

如此的表格,我想查询到12月21日为止,上月同期到本月同期的销量,即计算11月1-12月1的销量,11月2-12月2的销量,....一直计算出11月21-12月21的销量,列出如下结果:

中华 11月1-12月1销量
中华 11月2-12月2销量
....


中华 11月21-12月21销量

请问怎样编写程序???各位高手请帮帮忙!!!!

在线等待!!!

[wwwwb]

select name,sum(number) from tt where
[date] between
[date] and dateadd('m',1,[date])
group by name

[wwwwb]

改了一下：
SELECT name, date, dd, sum(number) AS sl, date&"-"&dd&"销量" AS nr
FROM [SELECT a.name, a.date, dateadd('m',1,a.[date]) as dd, b.number
FROM qqll AS b INNER JOIN qqll AS a ON (a.[name]=b.[name]) AND (b.[date] between a.[date] and dateadd('m',1,a.[date]))
ORDER BY a.name, a.date]. AS [%$##@_Alias]
GROUP BY name, date, dd;

[wwwwb]

or
SELECT a.name, a.date, dateadd('m',1,a.date),
(select sum(number) from qqll b WHERE a.[name]=b.[name] and format(b.[date],'yyyy-mm-dd') between format(a.[date],'yyyy-mm-dd') and format(dateadd('m',1,a.[date]),'yyyy-mm-dd'))
FROM qqll AS a
ORDER BY [name], [date];

[wwwwb]

SELECT a.name, a.date&"-"&dateadd('m',1,a.date)&"销量" AS nr, (select sum(number) from qqll b WHERE a.[name]=b.[name] and b.[date] between a.[date] and
dateadd('m',1,a.[date])) AS hj
FROM qqll AS a
ORDER BY [name], [date];

[imcomets]

好复杂。