$ sqlite3 output/chunks.sqlite "
SELECT 
    CASE 
        WHEN LENGTH(content) < 200 THEN '0-199文字'
        WHEN LENGTH(content) < 400 THEN '200-399文字'
        WHEN LENGTH(content) < 600 THEN '400-599文字'
        WHEN LENGTH(content) < 800 THEN '600-799文字'
        WHEN LENGTH(content) < 1000 THEN '800-999文字'
        ELSE '1000文字以上'
    END as size_range,
    COUNT(*) as count,
    ROUND(AVG(LENGTH(content)), 1) as avg_size,
    ROUND(COUNT(*) * 100.0 / (SELECT COUNT(*) FROM chunks), 1) as percentage
FROM chunks
GROUP BY size_range
ORDER BY avg_size;
"
