MariaDB [test]> select `ACXN[xo` from icecream;
+-----------------------------+
| ACXN[xo          |
+-----------------------------+
|                         464 |
|                         397 |
|                         493 |
|                         617 |
|                         890 |
|                         883 |
|                        1292 |
|                        1387 |
|                         843 |
|                         621 |
|                         459 |
|                         561 |
+-----------------------------+
12 rows in set (0.00 sec)

MariaDB [test]> select * from icecream where `ϋC`>=22;
+------+-----------------------------+--------------+--------+
|    | ACXN[xo          | ϋC     | G   |
+------+-----------------------------+--------------+--------+
|    5 |                         890 |         25.2 |      |
|    6 |                         883 |         26.3 |      |
|    7 |                        1292 |         29.7 | H     |
|    8 |                        1387 |         31.6 | H     |
|    9 |                         843 |         27.7 | H     |
|   10 |                         621 |         22.6 | ~     |
+------+-----------------------------+--------------+--------+
6 rows in set (0.00 sec)

MariaDB [test]> create table ice1 select ``, `ACXN[xo` from icecream;
MariaDB [test]> create table ice2 select ``, `ϋC` from icecream;
MariaDB [test]> create table icejoin select ice1.``, `ACXN[xo`, `ϋC` from ice1 inner join ice2 on ice1.``=ice2.``;

MariaDB [test]> select `G`, sum(`ACXN[xo`) from icecream group by `G`;
+--------+------------------------------------+
| G   | sum(`ACXN[xo`)          |
+--------+------------------------------------+
| ~     |                               1641 |
|      |                               2390 |
| t     |                               1354 |
| H     |                               3522 |
+--------+------------------------------------+
4 rows in set (0.00 sec)

MariaDB [test]> select count(*) from icecream where `ϋC`>=22;
+----------+
| count(*) |
+----------+
|        6 |
+----------+
1 row in set (0.01 sec)


MariaDB [test]> select `G`, avg(`ϋC`) from icecream group by `G`;
+--------+---------------------+
| G   | avg(`ϋC`)     |
+--------+---------------------+
| ~     |                17.3 |
|      |  23.933333333333334 |
| t     |  12.566666666666665 |
| H     |  29.666666666666668 |
+--------+---------------------+
4 rows in set (0.00 sec)

MariaDB [test]> select `G`, count(``) from icecream group by `G`;
+--------+--------------+
| G   | count(``)  |
+--------+--------------+
| ~     |            3 |
|      |            3 |
| t     |            3 |
| H     |            3 |
+--------+--------------+
4 rows in set (0.01 sec)
