בקשת תמיכה לחיבור classification_results table לטבלאות אחרות

[SStrong (Sophie Strong)]

@JammyDodger

SELECT target_type
FROM classification_results
GROUP BY 1 

I can only see post as a target_type. Am I correct in thinking that a post is a multiple of types in it’s on right as well. For example, one topic can have 10 posts in total. So does that mean that the sentiment analysis in this case would be applied 10 times, once to each post of a topic? Meaning if the ask was to create a dashboard which shows the sentiment score per topic by category, another step would be to then understand how many of the posts of a topic even have had sentiment analysis applied, then create an average?