with tmp as( select tag ,date(start_time) as dt ,sum(if_like) as daily_like #每一类视频每天的点赞量 ,sum(if_retweet) as daily_retweet #每一类视频每天的转发量 from tb_user_video_log left join tb_video_info using(video_id) where date(start_time) between '2021-09-25' and '2021-10-03' group by tag,date(start_time) ) select t...
投递SHEIN等公司6个岗位