SQLite 3.27

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

CREATE TABLE tablename(number INTEGER, ValueA INTEGER, ValueB INTEGER, ValueC INTEGER)
INSERT INTO tablename(number, ValueA, ValueB, ValueC) VALUES
(0, TRUE, TRUE, FALSE),
(1, TRUE, FALSE, TRUE),
(2, FALSE, FALSE, TRUE),
(3, TRUE, TRUE, TRUE);
WITH cte(total) AS (VALUES (0), (1), (2), (3))
SELECT c.total, COUNT(t.number) counter
FROM cte c LEFT JOIN tablename t
ON c.total = t.ValueA + t.ValueB + t.ValueC
GROUP BY total


total
counter


0
0

1
1

2
2

3
1


SELECT SUM(total = 0) total_0,
       SUM(total = 1) total_1,
       SUM(total = 2) total_2,
       SUM(total = 3) total_3
FROM (       
  SELECT ValueA + ValueB + ValueC total
  FROM tablename
)


total_0
total_1
total_2
total_3


0
1
2
1