I have a query with multiple joins that is being used to extract data from multiple tables.
As part of the select I have multiple case statements.
I a stuck with one of them. I need to add one condition where I get only one row each for Chris and John with flag 'Y', if they have PCT as 100 and the '0' or 'NULL' PCT rows should not be displayed.

| DeptID | Employee | PCT | Utlility\_PCT |
| --- | --- | --- | --- |
| 101 | Chris | 100 | Y |
| 101 | Chris |  | N |
| 101 | Sam | 0 | N |
| 101 | John | 100 | Y |
| 101 | John |  | N |

Currently my case statement is case when PCT = 100 then 'Y' else 'N' end Utility\_PCT

I want my result set to look like:

| DeptID | Employee | PCT | Utlility\_PCT |
| --- | --- | --- | --- |
| 101 | Chris | 100 | Y |
| 101 | Sam | 0 | N |
| 101 | John | 100 | Y |