这是个简单的问题，可是想不起来怎么做了，脑袋锈钭了！

[勤奋的阿拉丁]

原表示这样的：
id name country type
1 A USA Guest
2 B USA Admin
3 C CHN Guest
4 D CHN Guest

查询后想得到这样的结果：
type USA CHN
Admin 1 0
Guest 1 2

怎么写这个SQL语句呀？？

[smapple]

CASE

[jinjazz]

4分儿~~不是吧

[Softlee81307]

select type,usa=sum(case country when 'Usa' then 1 else 0 end),
chn=sum(case country when 'chn' then 1 else 0 end) from 表 group by type

[coeltdit]

select type,
sum(case when country='USA' then 1 else 0 end),
sum(case when country='CHN' then 1 else 0 end)
from tablename
group by type

[jxwangjm]

UP

[$扫地僧$]

select type,
sum(case when country ='CHN' then 1 else 0 end ) as CHN,
sum(case when country ='USA' then 1 else 0 end ) as USA
from t
group by type

[feihu_02]

select type,
sum(case when country='USA' then 1 else 0 end) as USA,
sum(case when country='CHN' then 1 else 0 end) as CHN
from table
group by type

[dwzhang_sh]

帮忙顶！！

[angel_zyz]

select tab3.typ,
count(decode(country,'USA',tab3.country,'')) USA,
count(decode(country,'CHIN',tab3.country,'')) CHIN
from tab3
group by tab3.typ;
調試過了,結果是對的!

[lwdjy]

帮忙顶！！
CASE

[Well]

angel_zyz(mayaa_013)的做法是錯啊
我調試過。
UP﹗﹗