SQL读取数据2

最新推荐文章于 2022-03-20 20:33:13 发布

_世界无限大_

最新推荐文章于 2022-03-20 20:33:13 发布

阅读量337

点赞数

本文链接：https://blog.csdn.net/qq_42474336/article/details/81205857

版权

统计粉丝情况

SELECT
   brands_id,
   count(DISTINCT pin) as 粉丝数
from
   (
       SELECT
           a.brands_id,
           b.created_time,
           b.pin
       from
           (
               SELECT
                   brands_id,
                   vender_id
               from
                   fdm.fdm_brands_fans_crm_brands_vender_info_chain
               where
                   dp = 'ACTIVE'
           )
           a
       LEFT JOIN
           (
               SELECT
                   pin,
                   created_time,
                   vender_id
               from
                   fdm.fdm_follow_vender_sns_follow_vender_stat_chain
               where
                   dp = 'ACTIVE'
                   and to_date(created_time) = '2018-07-17'
           )
           b
       on
           a.vender_id = b.vender_id
   )
   c
GROUP by
   brands_id