I have two queries that I'm trying to combine into one result set.

Query 1:

```
SELECT t1.evalID, t2.[Order], COUNT(t2.StepID) AS 'Total Categories'
FROM Evals t1
JOIN Steps t2 ON t1.TemplateID = t2.TemplateID 
JOIN GradingCats t3 ON t2.StepID = t3.StepID 
GROUP BY t1.EvalID, t2.[Order]
ORDER BY t2.[Order]

```

Query 2:

```
SELECT t4.EvaluatorID, t6.StepID, t6.[Order], COUNT(t4.Grade) AS 'Grades Entered'
FROM Grading t4
JOIN GradingCats t5 ON t4.GradingCatID = t5.GradingCatID 
JOIN Steps t6 ON t5.StepID = t6.StepID
GROUP BY t6.StepID, t4.EvaluatorID, t6.[Order]

```

My end goal is to locate which steps of an evaluation have missing grades.

edit (sample data):
Query #1

```
|---------------------|------------------|---------------------|
|      evalID         |     Order        |  Total Categories   |
|---------------------|------------------|---------------------|
|          81         |      01.00       |         17          |
|---------------------|------------------|---------------------|
|          81         |      02.00       |         17          |
|---------------------|------------------|---------------------|
|          81         |      03.00       |         17          |
|---------------------|------------------|---------------------|

```

Query #2

```
|---------------------|------------------|---------------------|------------------|
|     evaluatorID     |       Step       |        Order        |   Grades Entered |
|---------------------|------------------|---------------------|------------------|
|        1178         |        609       |        01.00        |        2         |
|---------------------|------------------|---------------------|------------------|
|        1178         |        615       |        02.00        |        3         |
|---------------------|------------------|---------------------|------------------|
|        9441         |        609       |        01.00        |        17        |
|---------------------|------------------|---------------------|------------------|
|        9441         |        609       |        02.00        |        17        |
|---------------------|------------------|---------------------|------------------|
|        9441         |        609       |        03.00        |        17        |
|---------------------|------------------|---------------------|------------------|

```