I am looking for a way to assess, and display graphically, the worklaod of two teams.

On one hand, I have a data set with projects as rows and start and end date for each of the Teams, A and B.

[Sample data](http://i.stack.imgur.com/okEgu.png)

On the other hand, I have a dataset with all days increments.

What I would want is the count of active projects each day for each team. In SQL, I would try a subquery...

Thanks for your help.