SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE myTable (`Col1` VARCHAR(4), `Col2` VARCHAR(4), `Col3` INT);
✓
INSERT INTO myTable (`Col1`, `Col2`, `Col3`) VALUES
  ('R1', 'C1', 5),
  ('R2', 'C3', 8),
  ('R1', 'C1', 2),
  ('R1', 'C2', 4),
  ('R2', 'C5', 3),
  ('R2', 'C2', 4);
✓
SELECT Col1, Col2, COUNT(*), SUM(Col3)
FROM myTable 
GROUP BY Col1, Col2


Col1
Col2
COUNT(*)
SUM(Col3)


R1
C1
2
7

R1
C2
1
4

R2
C2
1
4

R2
C3
1
8

R2
C5
1
3