The rows in The end result established that has a NULL are definitely the extra rows added by the ROLLUP clause. A NULL value within the column knowledge signifies a bunch of rows for a particular worth of dept_id but with no a particular skills worth.Finish In this question, we use CASE to define the wage vary for each staff. You'll be able to see