Count on F30026 & F4105

select current_timestamp,ieledg, iemmcu, count(distinct(IEITM)) from proddta.F30026
where
ieledg in ('02', '01', '07') and
iexsmc >0
group by ieledg, iemmcu
order by ieledg, iemmcu

----------------------------------------------------------------------------------------------


select to_char(systimestamp, 'HH24:MI:SS.FF3'),comcu,  coledg, count(*) from proddta.F4105
where coUNCS <> 0
and coledg = '01'
group by coledg, comcu order by coledg, comcu