select b.author_id, b.author_level, max(cnt) as days_cnt from ( select a.author_id, a.author_level, count(date_result) as cnt from( select t.author_id, t.author_level, date_sub(answer_date,interval t.rk day) date_result from( select author_id, author_level, answer_date, row_number() over(partitio...