家庭组活跃人次:使用到了 dense_rank()函数
-- 第N号家庭的第M个成员
SELECT fmlhost.code fmlhost_code,
fmlmember.code fmlmember_code,
DENSE_RANK() over (order by fmlhost.code) fmlhostN,
DENSE_RANK() over (partition by fmlhost.code order by fmlmember.code) fmlmemberM
FROM dim.dim_user fmlhost
join ods.ods_uses_account_user_relation r
on fmlhost.code = r.account_code and r.relation_type not in ('110','999') and r.deleted = 0
join dim.dim_user fmlmember
on r.user_code = fmlmember.user_code
having fmlhost_code in ('xxx');