SQL provides a summarized table of 6 unique count types broken out by client name. Clients are dynamic, not hard coded. Clients are included only if there is at least 1 Count Type is populated.
Here's a sample of the output below:
Client Name | Count Type 1 | Count Type 2 | Count Type 3 | Count Type 4 | Count Type 5 | Count Type 6 |
---|---|---|---|---|---|---|
Client A | 2 | 2 | ||||
Client B | 1 | 4 | 5 | 2 | 3 | 3 |
Client C | 2 | 5 | 6 | 3 | 3 | 4 |
Client D | 3 | 7 | 10 | 3 | 5 | 4 |
Client E | 2 | 2 | 1 | 1 | ||
Client F | 5 | 6 | 9 | 4 | 5 | 4 |
No Client | 1 | 2 | 2 | 1 | 1 | 1 |