select date_format (submit_time, '%Y%m') submit_month, count(uid) month_q_cnt, case when month (min(submit_time)) in (1, 3, 5, 7, 8, 10, 12) then round(count(uid) / 31, 3) else round(count(uid) / 30, 3) end avg_day_q_cnt from practice_record where year (submit...