求一数据库语句，

求一数据库语句，在线等。
现在，在同一张表里面有两个字段。
如下：

表名test
id name  

1 A

2 B

3 A

4 C

5 A
select name as name,count(*) as id from test where id='1' group by name

select name as name,count(*) as id from test where id>'3' group by name

就会有两个结果，我希望，能把这两句话组合，变成结果为:

name ida ida

 A 1 2



 

[解决办法]

SQL code

select * from     (select name as name,count(*) as id from test where id='1' group by name) tb1,    (select name as name,count(*) as id from test where id>'3' group by name)) tb2where tb1.name = tb2.name;