Count Occurence of all distinct values

Hi there!

Let us say I have a table with a  string based column 'Interests' holding strings separated by a delimiter

ID

How can I count the occurrence of every distinct interest in my table (without knowing all possible interests before, meaning they are not static, e.g. tomorrow another interest 'chess' might appear in my table)?

I.e. the expression shall give the following result:

I read about the SubField  and SubStringCount functions. But I cannot glue it together...