Sha256: 53388e4202eca0f4156d45ce215eff65b77ffe7e03b594ad5c24306d24111e2a
Contents?: true
Size: 625 Bytes
Versions: 16
Compression:
Stored size: 625 Bytes
Contents
CREATE OR REPLACE VIEW message_store.type_category_summary AS
WITH
type_count AS (
SELECT
type,
message_store.category(stream_name) AS category,
COUNT(id) AS message_count
FROM
message_store.messages
GROUP BY
type,
category
),
total_count AS (
SELECT
COUNT(id)::decimal AS total_count
FROM
message_store.messages
)
SELECT
type,
category,
message_count,
ROUND((message_count / total_count)::decimal * 100, 2) AS percent
FROM
type_count,
total_count
ORDER BY
type,
category;
Version data entries
16 entries across 16 versions & 1 rubygems