I'm trying to get some statistics in SQL query, how many open and closed tickets per agent per date. I have searched the forum for some query in sql, but I have not been lucky, however I have no idea how to solve it
![Sad :(](./images/smilies/icon_sad.gif)
For example
O = Open
C = Closed
Output
+--------+-------------------+
______ |06-20-17|06-19-17|...
+--------+-------------------+
| Agent | O | C | O | C |...
+--------+-------------------+
| Marco | 9 | 4 | 8 | 3 |...
| Stefan| 4 | 2 | 2 | 1 |...
| Marco | 5 | 5 | 6 | 4 |...
+--------+-------------------+
Could someone with knowledge in SQL query and database tables help me?
Thanks