In table class, There is a column class ids which stores the CSV value as a string like – A,B,C,D,E
Now, we have 5records with class ids – A,B,C – B,C,D- A,C,D- A,B,D, A,D

so, A is common in 5 records, we take it as 1, B is common , we take it is 1, same for C and D but E is not coming at once. So the result would be 1+1+1+1 =4.

can we make a query , to solve an handle this.

I created a table value function to get the single value from the csv data column.I look forward for the suggestions