数据库问题求oracle 语句

表test
name value
zhang A
zhang B
zhang A
zhang C
li A
li A
li B
wang B
wang B
wang C
lei A
lei B

结果
name value num
zhang A 2
zhang B 1
zhang C 1
li A 2
li B 1
wang B 2
wang C 1
lei A 1
lei B 1

select t.name,t.value count(t.name) num from table test t
group by t.name,t.value;

select t.name ,t.value,count(t.name ) as 'num' from test t
group by t.name ,t.value

请结贴！谢谢

额，不好意思，多了个table