To achieve this, you can use the SQL `GROUP BY` clause with the `COUNT()` and `COUNT(DISTINCT)` aggregate functions.

Let's assume your table is named `your_table`. You can use the following SQL query to count how many times the same value appears in column C per value in column B, and how many different values are in column B:

```
SELECT
  B,
  COUNT(C) AS count_C,
  (SELECT COUNT(DISTINCT B) FROM your_table) AS distinct_B_count
FROM
  your_table
GROUP BY
  B;
```

This query groups the results by column B, counts the occurrences of each value in column C for each value in column B, and calculates the total count of distinct values in column B as a separate column in the result set.

Please replace `your_table` with the actual table name in your database before running the query.
spam fails_task lang_mismatch pii not_appropriate hate_speech sexual_content quality toxicity humor helpfulness creativity violence