Better Translator translation demand histogram

histogram.sql

SELECT CASE
WHEN text_length < 10 THEN '< 10'
WHEN text_length BETWEEN 10 AND 100 THEN '< 100'
WHEN text_length BETWEEN 100 AND 1000 THEN '< 1000'
WHEN text_length BETWEEN 1000 AND 10000 THEN '< 10000'
ELSE '> 10000' END AS length_bucket,
COUNT(*) AS qty
FROM (SELECT *, length(original_text) AS text_length FROM translation) AS t GROUP BY length_bucket;