求两条SQL语句

Question

create table c
(
	cid int identity(1,1) primary key,
	ctype nvarchar(50)
)

create table s
(
	sid int identity(1,1) primary key,
	cid int not null,
	order_date datetime not null,
	amt int 
)

1.以cid分组，统计每个月不同产品（CID）的数量

2.以cid分组，统计每个月不同产品（CID）的数据

Answer 1

Did you ever try yourself? Can you post code you wrote?

Answer 2

您好，

请参考一下这个帖子中的语句：http://forums.asp.net/t/1707020.aspx

 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.