How we can count same column by filterin SQL Server:

Here Table:

```
id CodeType Code 
1   I        C001
1   I        M002
2   I        C002 
2   M        M003
3   I        C002 
3   M        M003

```

Sql output should like this:

```
Count WHEN CodeType I and Code  C001 with M002  :1
Count WHEN CodeType I and Code  C002 with M003  :2

```

How Can we do this with SQL Server