WITH TAB AS(
            SELECT '2020-06-01' DT ,6 CNT ,'검사실0' PLC FROM DUAL UNION ALL
            SELECT '2020-06-01',74,'검사실1' FROM DUAL UNION ALL
            SELECT '2020-06-01',23,'검사실2' FROM DUAL UNION ALL
            SELECT '2020-06-01',4,'검사실3' FROM DUAL UNION ALL
            SELECT '2020-06-01',7,'검사실4' FROM DUAL UNION ALL
            SELECT '2020-06-01',9,'검사실5' FROM DUAL UNION ALL
            SELECT '2020-06-01',20,'검사실6' FROM DUAL UNION ALL
            SELECT '2020-06-02',5,'검사실0' FROM DUAL UNION ALL
            SELECT '2020-06-02',80,'검사실1' FROM DUAL UNION ALL
            SELECT '2020-06-02',20,'검사실2' FROM DUAL UNION ALL
            SELECT '2020-06-02',2,'검사실3' FROM DUAL UNION ALL
            SELECT '2020-06-02',6,'검사실4' FROM DUAL UNION ALL
            SELECT '2020-06-02',5,'검사실5' FROM DUAL UNION ALL
            SELECT '2020-06-02',15,'검사실6' FROM DUAL UNION ALL
            SELECT '2020-06-03',7,'검사실0' FROM DUAL UNION ALL
            SELECT '2020-06-03',83,'검사실1' FROM DUAL UNION ALL
            SELECT '2020-06-03',22,'검사실2' FROM DUAL UNION ALL
            SELECT '2020-06-03',2,'검사실3' FROM DUAL UNION ALL
            SELECT '2020-06-03',7,'검사실4' FROM DUAL UNION ALL
            SELECT '2020-06-03',3,'검사실5' FROM DUAL UNION ALL
            SELECT '2020-06-03',17,'검사실6' FROM DUAL 
)
SELECT *
  FROM TAB
 PIVOT ( SUM(CNT) FOR PLC IN ('검사실0', '검사실1', '검사실2', '검사실3', '검사실4', '검사실5', '검사실6') )
 ORDER BY DT;

주의하실 것은 검사실 리스트가 정확히 IN 안에 들어가야한다는 점입니다.