在两个表上使用LEFT Joins时遇到问题

I've got three tables. Tickets, ticket history, and classification. I'd like to count how many tickets employees have completed, but broken down by classification.I've got three tables. Tickets, ticket history,