Table 4: Query Using CUBE and Results:
select units = sum(units_sold), name, language, country from product_sales_complete group by name, language,country with cube
Results:
units	name	language	country
55	Excel	English	Canada
39	Excel	English	Mexico
63	Excel	English	US
157	Excel	English	NULL
52	Excel	French	Canada
27	Excel	French	Mexico
64	Excel	French	US
143	Excel	French	NULL
9	Excel	Spanish	Canada
62	Excel	Spanish	Mexico
62	Excel	Spanish	US
133	Excel	Spanish	NULL
433	Excel	NULL	NULL
49	Word	English	Canada
71	Word	English	Mexico
62	Word	English	US
182	Word	English	NULL
54	Word	French	Canada
31	Word	French	Mexico
5	Word	French	US
90	Word	French	NULL
95	Word	Spanish	Canada
54	Word	Spanish	Mexico
87	Word	Spanish	US
236	Word	Spanish	NULL
508	Word	NULL	NULL
941	NULL	NULL	NULL
104	NULL	English	Canada
110	NULL	English	Mexico
125	NULL	English	US
339	NULL	English	NULL
106	NULL	French	Canada
58	NULL	French	Mexico
69	NULL	French	US
233	NULL	French	NULL
104	NULL	Spanish	Canada
116	NULL	Spanish	Mexico
149	NULL	Spanish	US
369	NULL	Spanish	NULL
116	Excel	NULL	Canada
198	Word	NULL	Canada
314	NULL	NULL	Canada
128	Excel	NULL	Mexico
156	Word	NULL	Mexico
284	NULL	NULL	Mexico
189	Excel	NULL	US
154	Word	NULL	US
343	NULL	NULL	US