题解 | #话题的分布情况#

select substring_index(substring_index(subject_set,',',2),',',1)

subject_id1,count(subject_set) cnt

from comment_detail

where substring_index(substring_index(subject_set,',',2),',',-1) ='1002'

group by subject_id1;