Display summary results based on empty value in another column
COUNT(expr) will count the number of rows where expr is not null, which can be used to figure out which groups have any nulls:




select officecode
     , case when count(*)&gt;count(auditdate) then 'Incomplete' 
            else 'Complete' end audit_status
from foo
group by officecode;



OFFICECODE | AUDIT_STATUS
:--------- | :-----------
DEF        | Complete    
ABC        | Complete    
XYZ        | Incomplete  



dbfiddle here

you can get the same result with nvl2 (or decode, etc):


select officecode
     , case when sum(nvl2(auditdate,0,1))&gt;0 then 'Incomplete' 
            else 'Complete' end audit_status
from foo
group by officecode;