sql语句--看若干应用的点击日活

select rpk_package, count(rpk_package) from ( 
    select distinct(imei), rpk_package from tableA 
where day = "2020-02-15" 
and rpk_package in ('aa', 'bb', 'cc')
) t 
group by rpk_package

 

还可以结合 join语句：

select pkgName, count(pkgName) from ( 
    select distinct(imei),pkgName from tableA a 
join tableB b on
a.params["pkgName"] = b.pkgName
where day = "2020-04-10") t 
group by pkgName;