MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test(
column1 BOOLEAN,
column2 BOOLEAN,
column3 BOOLEAN
);
INSERT INTO test VALUES (true, false, true);
INSERT INTO test VALUES (true, false, true);
INSERT INTO test VALUES (true, false, false);
INSERT INTO test VALUES (true, false, false);
INSERT INTO test VALUES (true, false, true);
INSERT INTO test VALUES (true, false, true);
SELECT GROUP_CONCAT(name ORDER BY total DESC) result
FROM (
  SELECT name, SUM(col) total
  FROM (
    SELECT 'column1' name, column1 col FROM test
    UNION ALL
    SELECT 'column2', column2 FROM test
    UNION ALL
    SELECT 'column3', column3 FROM test
  ) t
  GROUP BY name
) t;  


result


column1,column3,column2


SELECT name, SUM(col) total
FROM (
  SELECT 'column1' name, column1 col FROM test
  UNION ALL
  SELECT 'column2', column2 FROM test
  UNION ALL
  SELECT 'column3', column3 FROM test
) t
GROUP BY name
ORDER BY total DESC;


name
total


column1
6

column3
4

column2
0