| 123456789101112131415161718192021222324252627282930313233343536 |        select       a.account_id as `账户 `,       signature   as `视频md5`,       photo_url as `视频链接`,       video_name as `视频名称`,       project_name   `项目名称`,       clip_name      `剪辑`,       plan_name      `编导`,       shot_name      `拍摄`,       leader_name   `负责人`,       sum(charge) as `消耗`,       case when channel_type =0 then '内部' when channel_type=1 then '塑造' else '-' end as `渠道`from (select account_id,             signature,             channel_type,             project_name,             leader_name,             plan_name,             clip_name,             shot_name,             charge,             clip_company_id,             photo_url,             video_name      from application.kuaishou_material_video_report_daily_dw      where stat_date between 20220401 and 20220430) a         inner join (    select account_id    from `jeecg-boot`.ctop_user_allocation    where user_id in (        select user_id from `jeecg-boot`.user_company where company_id = 'd57fecdcf7a94d009736d9c850731582'    )) b                   on a.account_id = b.account_id where clip_company_id='1648c7ceb4d449a9a13fbed7a8d9976c'group by signature, a.account_id
 |