Description
You designed an OLAP database for Home Warrany Corporation. Based on that design, submit the following two SQL statements.
- Use the CUBE extension to show the sum of costs aggregated by all permutations of appliance serial, employee id, customer id, and year.
- Use the GROUPING SETS extension to show the same data.
