select 
   day,
    case when column_name in ('讲讲', '圈子') then '圈子页卡'
    when scene='逛逛圈子' and etype <> 'nearbyfeedhub' then '逛逛圈子信息流'  
    when scene='逛逛圈子' and etype = 'nearbyfeedhub'  then concat('头条逛逛圈子卡片_',extend_data['title'])
    when scene='身边卡片' then scene
    when column_name='社区::热门' then '社区::推荐'
    else column_name end as column_name,
    count(distinct concat_ws(',',eid,recommend_id,device_uuid)) exp_times
    from analyst.edm_galaxy_quanzi_motif_expo_and_click_clear_d_i
    where day>='20240628' 
    and ((circle_content_type = '圈子内容' and scene <> '圈子详情页内容曝光') or scene ='逛逛圈子')
    group by 
    case when column_name in ('讲讲', '圈子') then '圈子页卡'
    when scene='逛逛圈子' and etype <> 'nearbyfeedhub' then '逛逛圈子信息流'  
    when scene='逛逛圈子' and etype = 'nearbyfeedhub'  then concat('头条逛逛圈子卡片_',extend_data['title'])
    when scene='身边卡片' then scene
    when column_name='社区::热门' then '社区::推荐'
    else column_name end,day