SELECT B, COUNT(C) AS count_per_B, COUNT(DISTINCT B) AS distinct_B
FROM your_table_name
GROUP BY B;
spam fails_task lang_mismatch pii not_appropriate hate_speech sexual_content quality toxicity humor helpfulness creativity violence