带有“with by with cube”和NULL值的SQL查询

I have a table like:

我有一张桌子:

+------+------+------+
| col1 | col2 | col3 |
+------+------+------+
| A    | 1    | foo  |
| A    | 1    | foo  |
| A    | 2    | foo  |
| B    | 1    | foo  |
| B    | 2    | foo  |
| B    | NULL | foo  |
| NULL | 1    | foo  |
+------+------+------+
+------+------