sql查询

表A,有id,name,regdate.

1统计每月注册用户数，

2表中姓名同的用户数,

3问是如果A表有姓名相同的用户，把相同查出写入表C(id,name2)

 

 

select count(*) as uc, Month(regdate) from A group by Month(regdate)

select count(name) as uc from A group by name

insert into C select id,name from A where name in ( select name from A group by name )