Zalvena-Service/etc/clickhouse/queries/billing_usage_per_app__v1.liquid
2025-02-19 16:44:17 -05:00

5 lines
No EOL
163 B
Text
Executable file

SELECT replace(app_id, '_DEBUG', '') as AppId,
countMerge(events) as Count
FROM monthly_usage_v1
WHERE period = '{{period}}'
GROUP BY replace(app_id, '_DEBUG', '')