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 not 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';

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.