Buning uchun siz SQL `GROUP BY` klauzulasini `COUNT() ` va `COUNT(DISTINCT) ` yig'indirish funksiyalari bilan ishlatishingiz mumkin. Sizning jadvalingiz `your_table` deb nomlangan deb taxmin qilaylik. Siz quyidagi SQL so'rovidan foydalanib, C ustunida B ustunidagi har bir qiymat uchun bir xil qiymat necha marta paydo bo'lishini va B ustunida qancha turli qiymat borligini hisoblashingiz mumkin: `` SELECT B, COUNT(C) AS count_C, (SELECT COUNT(DISTINCT B) FROM your_table) AS_B_count FROM your_table GROUP BY; B `` Ushbu so'rov natijalarni B ustuni bo'yicha guruhlaydi, C ustunidagi har bir qiymatning B ustun
spam fails_task lang_mismatch pii not_appropriate hate_speech sexual_content quality toxicity humor helpfulness creativity violence