Status all counts
===

I have one table like below (MSSql)

**Name	Status**
kmk	Success
kmk	Success
mvk	Fail
per	Success
Per	Fail
mvk	Fail


I need the query which gives result like below

**Name	Status Count

kmk     Success 2
kmk     Fail    0
mvk	Success 0
mvk     Fail    2
Per     Success 2
Per     Fail    1


I tried many ways can you please give me the query
