I have a Table named "Calls". The table's columns are organized as

```
CallCounter, AssignedEmpID, CompletedByEmpID
1            200            200
2            200            200
3            201            200
4            200            200
5            201            201
6            201            200
7            200            200
8            200            200
9            200            201
10           201            201
...

```

How do I create a Select SQL query that will return the following data. Ideally I would like to complete the entire SQL query in 1 query. 

```
Employee    # Calls Assigned    # Calls Completed
200         6                   7
201         4                   3

```

I have tried the following queries

```
SELECT AssignedEmpID, COUNT(CallCounter) FROM CALLS
SELECT COUNT(*) FROM Calls

```