Can you help me to create a report with syntax?

[Mela]

I need reports for the tickets assess by Level 2 and Level 3 agent with their department.

Example: Mary is a L2 support in Data Science Department, therefore her tickets shall dispaly on reports under Data Science Department.

We have these department

• Solutions Management
  • System Support
  • System Delivery
• Service Management
  • Service Delivery
  • Operations & Monitoring
  • Infrastructure
• Data Science and Analytics

I am trying to make a query with but it doesn't match to the total tickets of all department. See the image below.

Here are my following syntax each of them:

Total of Tickets of Department - This should be the total of Service Management + Solution Management + Data Science.

issuetype in ("[System] Incident", "[System] Service request") AND status was in ("ACCEPT : LEVEL 2 SUPPORT", "ACCEPT : LEVEL 3 SUPPORT", "Level 2 Support", "Level 3 Support", "L2 SUPPORT", "L3 SUPPORT", "L2 ACCEPT TICKET", "L3 ACCEPT TICKET") AND (assignee in membersOf("Service Delivery") OR assignee in membersOf("Operations and Monitoring") OR assignee in membersOf(Infrastructure) OR assignee in membersOf("System Support") OR assignee in membersOf("System Delivery") OR assignee in membersOf("Data Science"))

Service Management - Consist of 3 Sub Departments which are Service Delivery, Operations and Management and Infrastructure.

issuetype in ("[System] Incident", "[System] Service request") AND status was in ("ACCEPT : LEVEL 2 SUPPORT", "ACCEPT : LEVEL 3 SUPPORT", "Level 2 Support", "Level 3 Support", "L2 SUPPORT", "L3 SUPPORT", "L2 ACCEPT TICKET", "L3 ACCEPT TICKET") AND (assignee in membersOf("Service Delivery") OR assignee in membersOf("Operations and Monitoring") OR assignee in membersOf(Infrastructure))

Solution Management - Consist of 2 Sub Departments which are System Support and System Delivery.

issuetype in ("[System] Incident", "[System] Service request") AND status was in ("ACCEPT : LEVEL 2 SUPPORT", "ACCEPT : LEVEL 3 SUPPORT", "Level 2 Support", "Level 3 Support", "L2 SUPPORT", "L3 SUPPORT", "L2 ACCEPT TICKET", "L3 ACCEPT TICKET") AND (assignee in membersOf("System Support") OR assignee in membersOf("System Delivery")) 

Data Science and Analytics - This is only a one Department

issuetype in ("[System] Incident", "[System] Service request") AND status was in ("ACCEPT : LEVEL 2 SUPPORT", "ACCEPT : LEVEL 3 SUPPORT", "Level 2 Support", "Level 3 Support", "L2 SUPPORT", "L3 SUPPORT", "L2 ACCEPT TICKET", "L3 ACCEPT TICKET") AND assignee in membersOf("Data Science")

That are my syntax each of them and I reviewed them one by one. Their declarations are correct. Names of Department in syntax are correct, even the name of status are correct. 

Is there something I missed?