Any idea how can I count unique values within a column when values are separated with comma (when there are more than one value)?

For example:

Expected result:

I'm using BigQuery.

Thanks!

CodePudding user response：

Try