Lets consider you have table
ProposalDetails(ProposalNO, ApplicationNo, Status, Locked)
having above data. Try following query it will make your picture clear.
SELECT ProposalNO,
SUM(1) [Applications],
SUM(CASE WHEN Locked = 'Y' THEN 1 ELSE 0 END) [Locked],
SUM(CASE WHEN Locked = 'N' THEN 1 ELSE 0 END) [UnLocked],
SUM(CASE WHEN Locked <> 'Y' AND Locked <> 'N' THEN 1 ELSE 0 END) [UnKnown]
FROM ProposalDetails
GROUP BY ProposalNO
Now you can add following condition to your query if you think its valid.
HAVING SUM(CASE WHEN Locked = 'N' THEN 1 ELSE 0 END) > 0