drop table if exists t1;
create table t1 (c1 int);

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  0))))))))))))))))))))
) as foo, 20
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  0)))))))))))))))))))))
) as foo, 21
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  0))))))))))))))))))))))
) as foo, 22
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  0)))))))))))))))))))))))
) as foo, 23
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  if(c1=24, 24,
  0))))))))))))))))))))))))
) as foo, 24
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  if(c1=24, 24,
  if(c1=25, 25,
  0)))))))))))))))))))))))))
) as foo, 25
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  if(c1=24, 24,
  if(c1=25, 25,
  if(c1=26, 26,
  0))))))))))))))))))))))))))
) as foo, 26
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  if(c1=24, 24,
  if(c1=25, 25,
  if(c1=26, 26,
  if(c1=27, 27,
  0)))))))))))))))))))))))))))
) as foo, 27
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  if(c1=24, 24,
  if(c1=25, 25,
  if(c1=26, 26,
  if(c1=27, 27,
  if(c1=28, 28,
  0))))))))))))))))))))))))))))
) as foo, 28
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  if(c1=24, 24,
  if(c1=25, 25,
  if(c1=26, 26,
  if(c1=27, 27,
  if(c1=28, 28,
  if(c1=29, 29,
  0)))))))))))))))))))))))))))))
) as foo, 29
from t1;

select
sum(
  if(c1=1, 1,
  if(c1=2, 2,
  if(c1=3, 3,
  if(c1=4, 4,
  if(c1=5, 5,
  if(c1=6, 6,
  if(c1=7, 7,
  if(c1=8, 8,
  if(c1=9, 9,
  if(c1=10, 10,
  if(c1=11, 11,
  if(c1=12, 12,
  if(c1=13, 13,
  if(c1=14, 14,
  if(c1=15, 15,
  if(c1=16, 16,
  if(c1=17, 17,
  if(c1=18, 18,
  if(c1=19, 19,
  if(c1=20, 20,
  if(c1=21, 21,
  if(c1=22, 22,
  if(c1=23, 23,
  if(c1=24, 24,
  if(c1=25, 25,
  if(c1=26, 26,
  if(c1=27, 27,
  if(c1=28, 28,
  if(c1=29, 29,
  if(c1=30, 30,
  0))))))))))))))))))))))))))))))
) as foo, 30
from t1;