select a.author_id, b.author_level, a.days_cnt FROM ( select t1.author_id, count(distinct t1.answer_date) days_cnt from ( select t.author_id, t.answer_date, t.answer_date - t.ranking dt FROM ( select author_id, answer_date, dense_rank() over ( PARTITION BY author_id order by answer_date ) ranking fr...