sql

SELECT
  COUNT(*) AS CNT
FROM
  TEST_TBL
WHERE
  COL1 = 'AAA'
AND
  COL2 = 'BBB'
GROUP BY
  COL1