SQLite 3.39

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

CREATE TABLE test (col1 int, col2 int);
✓
INSERT INTO test (col1, col2)
VALUES
  (1, 1)
, (2, 1)
, (2, 2)
, (3, 1)
, (3, 1)
, (3, 1)
, (3, 2);
✓
SELECT col1, col2, col1 + col2 AS col1, COUNT(*) AS col3  
FROM test  
GROUP BY col1, col2;


col1
col2
col1
col3


1
1
2
1

2
1
3
1

2
2
4
1

3
1
4
3

3
2
5
1


SELECT col1, col1 + col2 AS col1, COUNT(*) AS col3  
FROM test  
GROUP BY col1, col2  
HAVING col1 = col3;


col1
col1
col3


1
2
1

3
4
3