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=4 GROUP BY dt_year , dt_month ,dt_day , app_type_id ORDER BY dt_year DESC, dt_month DESC, dt_day DESC 2025-03-15 18:03:43 done