launching for Dutch; part 1: content

I launched LangBear for Swedish as this is the language that I'm myself learning. So far however, I had not been able to acquire a single customer -- neither a paying nor just an active one.

I decided to try with the Dutch language next as the total addressable population is supposed to be larger.

First, I need to work on content quantity:

SELECT
  data->>'level' as level,
  COUNT(1) as level_count,
  SUM(COUNT(1)) OVER () AS total_count
FROM exercises 
WHERE lang = 'nl' AND type = 'text_quiz'
GROUP BY data->>'level'
ORDER BY data->>'level';

level	level_count	total_count
A1	3	55
A2	6	55
B1	35	55
B2	7	55
C1	4	55

These numbers come mainly from the translations of base copies of Swedish texts. The target is to have around 200 texts total with equal distribution among them.