The script below shows how many credits were created by each user
select b.UserCode ,
count(b.credit_Number) as "Number of Credits by UserCode "
from ar_customer a, ar_credit b
where a.customer_id=b.customer_id
and a.customer_id<>1
and b.credit_id >1
group by b.UserCode
