UnisKB/apps/application/sql/customer_count_trend.sql

7 lines
175 B
MySQL
Raw Permalink Normal View History

2025-06-09 13:08:04 +00:00
SELECT
COUNT ( "application_chat_user_stats"."id" ) AS "customer_added_count",
create_time :: DATE as "day"
FROM
"application_chat_user_stats"
${default_sql}
GROUP BY "day"