select * from( select tag, day, sum(sum_like_day), max(sum_re_day) from( select day, tag, sum(if_like) sum_like_day, sum(if_retweet) sum_re_day from( select '2021-10-01' day, tag, if_like, if_retweet, date from ( selec...