university of maryland the red sentences

Compare the results of a GROUP BY ROLLUP and a GROUP BY CUBE. Explain the differences YOU see.??? Problem 1: Determine the Appropriate Function and Write a QUERY: ─ Choose a table that has a column with a number data type. Make sure this column is one that makes sense to take the average of. I chose EMPLOYEES table ─ Then return the rounded average of that column. ─ GROUP the data by another column in the table. ─ Choose the fields for your query My Query: Select DEPARTMENT_ID, ROUND(AVG(SALARY), 2) as AVERAGE_SALARY, MAX(SALARY) as MAX_SALARY From EMPLOYEES Group by DEPARTMENT_ID Order by DEPARTMENT_ID; Problem 2: Determine the Appropriate Command and Write a QUERY: Redo problem 1, to not suppress any duplicates. What did you notice about the change of results?