您缺少许多单引号和其他随机*和"字符，并且FROM子句wincert owner. PRINT_QUEUE pq无效（您是指_而不是``吗？）：

select pq CLIENT_NM,
       pq.SENDER NM,
       count(pq.ARCHIVE ID) as CertCount,
       to_char(pq.SUBMIT_DT, 'yyyy.mm.dd') as SubmitDate,
       to_char(pq.PROCESS_DT, 'yyyy.mm.dd') as ProcessDate,
       pq.STATUS 
from   wincert_owner.PRINT_QUEUE pq
where  to_char(pq.PROCESS_DT, 'yyyy.mm.dd') = to_char(SYSDATE - 1, 'yyyy.mm.dd')
group by
       pq.CLIENT_NM,
       pq.SENDER_NM,
       to_char(pq.SUBMIT_DT, 'yyyy.mm.dd'),
       to_char(pq.PROCESS_DT, 'yyyy.mm.dd'),
       pq.STATUS 
Order by 1,2;