如何取得各組織的線上人數

各組織的線上人數

SELECT   hou.organization_id,
         hou.NAME organization_name,
         COUNT(*) online_num
FROM     (SELECT DISTINCT responsibility_id,
                          user_id
          FROM            fnd_signon_audit_view) a, (SELECT *
                                                     FROM   org_access oa) oa,
         (SELECT *
          FROM   hr_all_organization_units_tl hou
          WHERE  LANGUAGE = 'US') hou
WHERE    a.responsibility_id = oa.responsibility_id(+)
AND      oa.organization_id = hou.organization_id(+)
GROUP BY hou.NAME, hou.organization_id;