8 lines
No EOL
165 B
SQL
Executable file
8 lines
No EOL
165 B
SQL
Executable file
CREATE OR REPLACE VIEW monthly_usage_v1
|
|
AS
|
|
SELECT
|
|
app_id,
|
|
toStartOfMonth(timestamp) AS period,
|
|
countState() AS events
|
|
FROM events
|
|
GROUP BY app_id, period |