dpaste/G04Ds (Python)

SELECT charac, count(*) as frequency
FROM (
SELECT regexp_split_to_table(content, '')
FROM (
SELECT STRING_AGG(content, '') as content
FROM "some_table"
WHERE "some_condition" = 'is_met'
) charac(l)
)
GROUP BY charac;

Edit this Snippet

Syntax

Expires

Right-to-Left

Content SELECT charac, count(*) as frequency FROM ( SELECT regexp_split_to_table(content, '') FROM ( SELECT STRING_AGG(content, '') as content FROM "some_table" WHERE "some_condition" = 'is_met' ) charac(l) ) GROUP BY charac;