title: Return row if it matches values, unless its unique identifier matches the wrong value
body: <p><b> Problem: </b></p>
  <p>I have a table that looks like this:</p>
  <p><a href="https://i.stack.imgur.com/KVcXh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KVcXh.png" alt="enter image description here" /></a></p>
  <p>I would like to return the following:</p>
  <p><a href="https://i.stack.imgur.com/ioZLc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ioZLc.png" alt="enter image description here" /></a></p>
  <p>I want to return only groups of Project Categories where all projects within that category can only be a stage of Closed.</p>
  <p><b>What I've Tried:</b>
  This is as far as I have gotten but it only produces a list of all projects that have a stage of closed, but I wanted to exclude project categories where any of its projects are not closed.</p>
  <pre><code>  SELECT Project_Category, Project, Stage, Reason
    FROM Table
    WHERE Project_Category IN (
      SELECT Project_Category
      FROM Table
      GROUP BY Project_Category
      HAVING COUNT(DISTINCT Project) &gt; 1
    )
    AND Stage = 'Closed'
    AND Reason = 'no award'
    ORDER BY Project_Category
  </code></pre>