Quiz on SQL GROUPING SETS

What is the purpose of GROUPING SETS in SQL?

Which SQL keyword is most closely related to GROUPING SETS?

Which of the following is equivalent to:

GROUP BY GROUPING SETS ((region), (product))

What will be the output of the following?

SELECT region, product, SUM(sales)
FROM orders
GROUP BY GROUPING SETS ((region), (product));

What does the empty set `()` represent in `GROUPING SETS`?

What will this return?

GROUP BY GROUPING SETS ((region), ())

Which clause allows similar functionality to `GROUPING SETS`?

What is the major benefit of `GROUPING SETS` over multiple `GROUP BY` queries?

Which of the following supports `GROUPING SETS`

What does this query return?

SELECT department, role, COUNT(*)
FROM employees
GROUP BY GROUPING SETS ((department), (role), ());

Which keyword helps to identify if a column is aggregated in a `GROUPING SET` result?

What is the output of `GROUPING(column_name)` if the value is NULL due to aggregation?

Which of the following is **not** a valid grouping set?

How is `ROLLUP(a, b)` interpreted internally?

Which clause generates all combinations of the specified columns?