select
CI.C07_special_code,
count(distinct ci.isr_no)
from c07_special_table ci, isr i
where i.isr_no = ci.isr_no
--and ci.C07_START_DATETIME BETWEEN '16-MAR-22 02.00.00.000000000 PM UTC' AND '16-MAR-22 04.15.00.000000000 PM UTC'
and ci.C07_START_DATETIME >= '16-MAR-22 02.00.00.000000000 PM UTC'
and ci.C07_START_DATETIME <= '16-MAR-22 04.15.00.000000000 PM UTC'
and i.isr_no like 'PECO%'
group by CI.C07_special_code
select CI.C07_special_code, count(distinct ci.isr_no) from c07_special_table ci, isr i where i.isr_no = ci.isr_no --and ci.C07_START_DATETIME BETWEEN '16-MAR-22 02.00.00.000000000 PM UTC' AND '16-MAR-22 04.15.00.000000000 PM UTC' and ci.C07_START_DATETIME >= '16-MAR-22 02.00.00.000000000 PM UTC' and ci.C07_START_DATETIME <= '16-MAR-22 04.15.00.000000000 PM UTC' and i.isr_no like 'PECO%' group by CI.C07_special_code
 column NAME_OF_THE_COLUMN format A30
select external_no1, s_mode, p_origin
GoBack