RUN SELECT year(DT) AS dt_year, app_type_id, month(dt) AS dt_month, DAYOFMONTH(dt) AS dt_day, count(DISTINCT user_id) AS total_active FROM log_user_by_day WHERE dt>=? AND app_id=1 GROUP BY dt_year , dt_month ,dt_day , app_type_id ORDER BY dt_year DESC, dt_month DESC, dt_day DESC 2025-06-06 - daily - 4 - get_active_user_stats 2025-06-06 - daily - 5 - get_active_user_stats 2025-06-05 - daily - 4 - get_active_user_stats 2025-06-05 - daily - 5 - get_active_user_stats 2025-06-04 - daily - 4 - get_active_user_stats 2025-06-04 - daily - 5 - get_active_user_stats 2025-06-03 - daily - 4 - get_active_user_stats 2025-06-03 - daily - 5 - get_active_user_stats 2025-06-06 15:12:07 done