'Querying the same amount of labels in Presto

I have a field in a table named types and this field can have one or more type value, like this:(they are string inside [] and all between ""

["type1","type2"]
["type1"]
["type3","type4","type11"]

This table has 100 distinct type of types values.

What I need: I want to query this table in a way that I can ensure that I will have the same count of each type value, let's say:

100type1, 100type2,... 100type100

In the above example, I have 2 types1..



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source