I need to show count associated with each group even if the count is zero, however the query below shows shows non empty groups only. Could anyone please review the query.
select RAW count(1) from
left outer join
on META(act).id = ci.accountToken
act.packageName = “VR3” and
act.status = ‘ACTIVATED’ and