The rows in the result established which has a NULL are definitely the extra rows added through the ROLLUP clause. A NULL benefit inside the column expertise signifies a bunch of rows for a specific value of dept_id but without the need of a particular know-how benefit.Should you have two tables Using the same schema or if two tables have a subset