SELECT INST_NO,TRUNC(INS_TS) AS INS_TS, COUNT(*) AS TOTAL_INSPECTION FROM TABLE1
WHERE INST_NO='M190200772' GROUP BY INST_NO, TRUNC(INS_TS)

**RESULT OF QUERY 1:**
INST_NO      INS_TS      TOTAL_INSPECTION
M190200772   18-FEB-19         8
M190200772   19-FEB-19         3

SELECT INST_NO, TRUNC(INS_TS) AS INS_TS, COUNT(*) AS CASE_INSPECTION FROM TABLE2
WHERE INST_NO='M190200772' AND QTY_OK IN (0) GROUP BY INST_NO, TRUNC(INS_TS)

**RESULT OF QUERY 2:**
INST_NO      INS_TS      CASE_INSPECTION
M190200772   18-FEB-19          4
M190200772   19-FEB-19          2

INST_NO      INS_TS      INSPECTION    CASE
M190200772   18-FEB-19       8           4
M190200772   19-FEB-19       3           2