QUESTION:

 What does the rollup sub clause provide in terms of grouping and how does it differ from the CUBE sub clause?

What is the purpose of the GROUPING SETS sub clause and what is its primary use?