I have a table like the below and want to identify duplicate referrals

```
Client      Team                Referred Date

client1     Referred Team1      2016-02-16
client1     Referred Team1      2016-02-16
client1     Referred Team1      2016-02-16
client1     Referred Team1      2016-01-28
Client2     Referred Team4      2015-07-03
Client2     Referred Team4      2015-07-03
Client3     Referred Team7      2015-04-09
Client3     Referred Team7      2015-04-09
Client3     Referred Team7      2015-04-09
Client3     Referred Team2      2016-09-28
Client3     Referred Team1      2016-10-20
Client4     Referred Team8      2016-11-18

```

My query so far below, but i dont seem to get the desired result

```
SELECT 
ClientId
,Team
,COUNT(*) as DuplicateCount

FROM MyData
group by 
ClientId
,Team
having COUNT(*) >1

```

I would like the below result

```
Client      Team                Duplicate Count (Times referred to the same team)

client1     Referred Team1      4
Client2     Referred Team4      2
Client3     Referred Team7      3
Client4     Referred Team8      1

```

thanks in advance